Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “collop” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

422 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
collop10731231(None) 
collops112611751collops
dollop9259361dollop
lollop8238781lollop
scollop11275431scollop
bollox1548742bollox
callow114714662callow
cello74919582cello_
cellos84517802cellos
clop86929892c__lop
coelom10310422coelom
collar83816172collar
collet84030362collet
collie83621992collie
colloid10312882colloid
colly104926772coll_y
colog86619932co_log
colon78630192co_lon
color76123742co_lor
coop87238652co__op
coplot10518272coplot
cowflop1742892cowflop
cowplop1643362cowplop
dollops10287962dollops
follow124010352follow
gallop93311382gallop
hollo84822162hollo_
holloa94914822holloa
holloo94415252holloo
hollos95320632hollos
hollow124212662hollow
lollops9227442lollops
lollopy12234772lollopy
orlop7410902_orlop
rollmop1142992rollmop
rolltop944042rolltop
scallop11237642scallop
scollops12235702scollops
trollop944792trollop
wallop113310292wallop
allod64418383_allod
allot54933873_allot
allow85420663_allow
alloy85519973_alloy
apollo837183apollo_
apollos946793apollos
ballon84117493ballon
ballot84624093ballot
bellhop1445053bellhop
bellow114213353bellow
billon83713833billon
billow114111223billow
bloop96116153_bloop
boll65634753boll__
bolled94722653bolled
bollix1538053bollix
bolls75531313boll_s
bolo65535953bo_lo_
bolos75531373bo_los
bolson8410683bolson
call66838673call__
calla74827073call_a
callan83619603callan
callas84526753callas
callboy1465833callboy
called94126733called
callee84327293callee
caller85125483caller
callet84536763callet
calliope1256223calliope
callose9313663callose
callous93516603callous
calls75634733call_s
callus85317073callus
calo64936443c_alo_
calos74431903c_alos
caltrop11267643caltrop
carhop133610763carhop
cartop104213563cartop
cell65031723cell__
cella75420313cell_a
cellae84915933cellae
cellar84514983cellar
celled94420323celled
celli76717693cell_i
cells75428063cell_s
celom9515683c_elom
challot123613263challot
chalot113020133chalot
cholla113911023choll_a
chollas123811353chollas
cholo105217973cholo_
cholos114716853cholos
chop116024923c__hop
clamp115517653c_lamp
clap86429043c__lap
clasp95517193c_lasp
clip86924003c__lip
clod76124613c__lod
clog76123243c__log
clomp115615703c_lomp
clon66232483c__lon
cloot76127053c_loot
clops95924853c__lops
clot66542423c__lot
cloy96623833c__loy
clump115517453c_lump
coal66939253coal__
coala77521123coal_a
coalas87418963coalas
coalbox1844113coalbox
coaled95022703coaled
coaler84121713coaler
coals76129603coal_s
coaly105521593coal_y
coble94823173cobl_e
cobles104622883cobles
cockup1635713cockup
coco87330603co_co_
cocoa98517883co_coa
cocoon10312263cocoon
cocos95624693co_cos
codlin94516443codlin
codon86522853co_don
coelome1139683coelome
coeloms1139063coeloms
cogon89120903co_gon
coho97524493co_ho_
cohog117813043co_hog
cohos105921853co_hos
coil66439653coil__
coiled95123933coiled
coiler84421593coiler
coils75030083coil_s
col59360353co_l__
cola66541393co_l_a
colas75436773co_las
colby124415063co_lby
colbys13407153colbys
cold77338773co_l_d
colder95121843colder
coldly12459953coldly
colds85726973co_lds
cole66956113co_l_e
colead94114643colead
coled85540753co_led
coles76055063co_les
coleus86818273coleus
colic95726173co_lic
colics104219903colics
colies84837053colies
colin76231693co_lin
colins85229043colins
collage102813753collage
collapse1244273collapse
collard103712923collard
collars93816573collars
collate92919683collate
collator10310373collator
collect113314593collect
colleen939533colleen
college102410433college
collets93517903collets
collide103214783collide
collied103316673collied
collier93618153collier
collies94326583collies
collins93419833collins
collogue1145463collogue
colloids11310173colloids
colloquy2243033colloquy
collotype1643383collotype
collotypy1952103collotypy
collude10337983collude
colobi105011083colobi
cologs96517353cologs
colone85425003colone
coloni85619203coloni
colons86028683colons
colony115417273colony
colors86622373colors
colour85915093colour
cols66553083co_l_s
colt67158243co_l_t
colter84625093colter
colts76633293co_lts
colugo935863colugo
colugos1035693colugos
column1038103column
colure8314163colure
coly96940533co_l_y
colza165112983co_lza
colzas174010513colzas
combo114519433combo_
combos125316613combos
common12310803common
comp106731253co__mp
complot13310683complot
compo115318573compo_
compos124818803compos
condo85322593condo_
condom114215363condom
condor94616973condor
condos94322333condos
congo85623133congo_
congos94219883congos
congou94313243congou
consol82614113consol
conto76027173conto_
contos84923233contos
convoy14348543convoy
coo59566363co__o_
coocoo1069693coocoo
coof96643273co__of
cook107236933co__ok
cooktop1544043cooktop
cool66940493co__ol
cooled95224583cooled
cooler84824713cooler
coolie83821603coolie
coolly114811393coolly
cools75632633cool_s
coolth1139513coolth
cooly105525423cool_y
coon67248943co__on
coops96229643co__ops
coopt95929853co__opt
coos67456493co__os
coot67860383co__ot
cop711162373c___op
copilot11811263copilot
coplots11511593coplots
cordon95017293cordon
cosmos10311753cosmos
cotillon1045053cotillon
cotton8312993cotton
could86517713coul_d
coulee8323503coulee
coulis84018763coulis
couloir936153couloir
coulomb1344553coulomb
coup86729793co__up
coupon102810993coupon
cowboy1637063cowboy
cowflap1742503cowflap
cowflops1842983cowflops
cowl97530813cowl__
cowled125218383cowled
cowls106922213cowl_s
cowplops1743173cowplops
cowpox2035003cowpox
cowslip1444013cowslip
coydog1335133coydog
coyly135614893coyl_y
coypou13268403coypou
criollo943953criollo_
criollos1043713criollos
crop87628633c__rop
cull65929643cull__
cullay113910173cullay
culled94022473culled
culler84322253culler
cullet84727313cullet
cullion91910233cullion
cullis84115993cullis
culls75425813cull_s
cully105520463cull_y
cyclo1237703cyclo_
cyclops1635383cyclops
cyclos1338073cyclos
doblon938013doblon
doll56632493doll__
dollar74110983dollar
dolled83518073dolled
dolloped1234983dolloped
dolls66126923doll_s
dolly96125203doll_y
dolor67617963do_lor
doowop1283853doowop
escallop1243193escallop
fallow124713853fallow
felloe93513923felloe
fellow123712743fellow
fillip11268953fillip
fillo84319783fillo_
fillos94415083fillos
flop96925453__flop
foldup1233813foldup
folio83820883folio_
folios93915463folios
folles93820473folles
follis93113903follis
follows13409923follows
followup1642173followup
folly115022603foll_y
gallon73715813gallon
gallops103211653gallops
galop84716223_galop
glop76724633__glop
golly95121103goll_y
goop75829483go__op
hallo85127553hallo_
halloa94918123halloa
halloo95118973halloo
hallos95425103hallos
hallot95426783hallot
hallow124818323hallow
hello86522983hello_
hellos95321683hellos
hillo84721653hillo_
hilloa94713033hilloa
hillos94618893hillos
hilltop1244783hilltop
holdup1245183holdup
holla84918493holl_a
hollas94616903hollas
holler93520613holler
holloas103814943holloas
holloed113812753holloed
holloes103818193holloes
holloos104013583holloos
hollows134412333hollows
holly114824433holl_y
holp95727553ho_l_p
hoop96129983ho__op
hullo84417453hullo_
hulloa95011183hulloa
hulloo94511733hulloo
hullos94916293hullos
jalop144212603_jalop
jello126716273jello_
jellos134714283jellos
jolly154517513joll_y
joypop2063133joypop
kolhoz2264773kolhoz
kolkoz1864283kolkoz
kolo87026223ko_lo_
kolos94921213ko_los
loll46128383loll__
lolled74315823lolled
loller63315283loller
lollipop1241883lollipop
lolloped1134463lolloped
lolls512121733loll_s
lolly85120663loll_y
lollypop1551813lollypop
loop67835013__loop
lop58255313___lop
mallow114014743mallow
mellow114112223mellow
moll66735703moll__
mollah11319453mollah
mollie83517103mollie
molls75129783moll_s
molly105222493moll_y
molto75619603molto_
nolo46229313no_lo_
nolos54423353no_los
ocelot8813383ocelot
oleo46630483_oleo_
oleos55419683_oleos
olio46829673_olio_
olios54520853_olios
olla44821173_oll_a
ollas54218283_ollas
orlon5415003_orlon
orlops847303_orlops
oxlip1456883_oxlip
pallor8313673pallor
pillow113110573pillow
plop86625743__plop
polio75722553polio_
polios84019723polios
poll66332133poll__
polled94022003polled
pollee83623273pollee
pollen83416453pollen
poller83921853poller
pollex153711163pollex
pollock1546843pollock
polls74627723poll_s
polo66236633po_lo_
polos76129913po_los
polyol1138713polyol
polyp125611533po_lyp
poop86532813po__op
postop10511943postop
pullup1045893pullup
roll46331653roll__
rolled74220243rolled
roller63919793roller
rollmops1243003rollmops
rollout7811943rollout
rolls55326233roll_s
sallow94315753sallow
saloop84212583saloop
scallops12297393scallops
scolloped1443653scolloped
scoop95617163sco__op
shallop12348453shallop
sloop76118913_sloop
slop66533873__slop
soldo67116563soldo_
solion6616383solion
solo45538943so_lo_
solon55026133so_lon
solos54830793so_los
tallol63612223tallol
tallow93714203tallow
toll45535263toll__
tolled73819033tolled
toller63819443toller
tolls54728433toll_s
toluol636903toluol
trollops1044813trollops
trollopy1343273trollopy
volley12419743volley
volvox1933363volvox
wallops123410413wallops
wallow123913513wallow
willow12369693willow
yellow12429883yellow

Search took 6 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911127160.1401276364.3
2DLD Change Limit1127164225.28021347.7
3Display Results4224220.1432951.0
 (SQL Overall)1786914225.56332121.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.