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 “collide” 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.

366 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
collide10321478(None) 
collided12309791collided
collider113410411collider
collides113214461collides
collie83621991colli_e
collied103316671collied
collude10337981collude
bolide9515562bo_lide
collage102813752collage
collate92919682collate
college102410432college
colliders12298072colliders
collier93618152collier
collies94326582collies
collins93419832collins
colloid10312872colloid_
colloids11310172colloids
colluded12296452colluded
colluder11276862colluder
colludes11279212colludes
confide13310202confide
coolie83821602cooli_e
cowhide1636132cowhide
cullied104012352cullied
dollied93811142dollied
jollied15349272jollied
mollie83517102molli_e
toluide835262toluide
allied74217153_allied
allude73910903_allude
ballade104012563ballade
bellied104314073bellied
billie85019173billi_e
bolides10515073bo_lides
bolled94722653bolled_
bolling103820883bolling
bollix1538053bolli_x
bollixed1834483bollixed
bollixes1747203bollixes
boltlike1436313boltlike
boride9415903bo_ride
bowlike16349473bowlike
bowline123613113bowline
bowllike1734863bowllike
boxlike20267073boxlike
bullied104514813bullied
calcine11315273calcine
calcite11413783calcite
calflike1735153calflike
called94126733called_
callee84327293call_ee
calling103826773calling
calliope1256223calliope
callipee1237733callipee
calliper1247513calliper
callose9313653callose
carbide126112493carbide
carline93923613carline
catlike132712933catlike
cauline92215603cauline
ceilidh1345363ceilidh
cellae84915933cell_ae
celled94420323celled_
celli76717693celli__
celling103921263celling
cellist9314423cellist
cellule936523cellule
chalice14311043chalice
challie124012853challi_e
chide115321013c__hide
childe124711213chil_de
chloride143310243chloride
choline122915383choline
cilice103213353c_ilice
clade85821013c__lade
clime95720893c__lime
cline76428533c__line
coaled95022703coaled_
coalier93416173coalier
coalify1536683coalify
coaling103722823coaling
coble94823173cobl__e
cocaine111315173cocaine
coccid102910743coccid_
coccids11277213coccids
cockade1638133cockade
cocklike1536733cocklike
code77347733co___de
codeine103815033codeine
codlin94516433codli_n
codling114418953codling
codlins104116243codlins
codrive1337643codrive
coeliac1138233coeliac
coelome1139683coelome
coesite9713623coesite
cognise1059683cognise
cognize1957683cognize
coiled95123933coiled_
coiling103723453coiling
coincide1346493coincide
cokelike1336813cokelike
colander1139033colander
cold77338773co_l_d_
colder95121833co_l_der
coldish1399303coldish
colds85726973co_l_ds
cole66956113co_l__e
colead94114643colead_
coleader1139173coleader
coleads102911423coleads
coled85540753co_led_
colic95726173co_li_c
colicine12312993colicine
colics104219903co_lics
colies84837053co_lies
colin76231693co_li_n
colins85229043co_lins
collaged12279963collaged
collagen11338563collagen
collages113514233collages
collapse1244273collapse
collar83816173coll_ar
collard103712923collard
collards113310193collards
collared113211143collared
collaret103116703collaret
collars93816573collars
collated113615063collated
collates103019133collates
collect113314593collect
colleen939533colleen
colleger11227923colleger
colleges112410513colleges
collet84030363coll_et
colleted113011653colleted
collets93517903collets
colliding1338583colliding
colliers103613583colliers
colliery13307363colliery
colligate1248293colligate
collimate1348163collimate
collinear1144113collinear
collinses1138283collinses
collogue1145463collogue
colloidal1244903colloidal
collop107312313coll_op
collops112611753collops
colluders12285613colluders
collusive1444933collusive
colly104926773coll__y
collying14319543collying
cologne1039353cologne
colone85425003co_lone
colonise102514283colonise
colonize192312773colonize
colored10313473colored
colorize192314203colorize
coltish121310933coltish
colure8314153co_lure
comade114415323co_made
combine133014723combine
comblike1846293comblike
commie124215523commi_e
commode1438123commode
compile13312443compile
complice1639333complice
complied1539673complied
compline14313553compline
comrade12139213comrade
concede12310093concede
concise11314473concise
conclude1344663conclude
confided1537453confided
confider1438123confider
confides14310573confides
confine12315583confine
coniine9316803coniine
conine84528553co_nine
connive1238993connive
conoid9818883conoid_
conoids10813883conoids
consider11310393consider
cookie123716043cooki_e
cooled95224583cooled_
coolies93824963coolies
cooling103422573cooling
coolish12312523coolish
cootie84223073cooti_e
copied114618563co_pied
coppice1537483coppice
coralline1147943coralline
corbie103618203corbi_e
cordite10315253cordite
cordlike1537233cordlike
corklike1335993corklike
cormlike1646703cormlike
cornice11612933cornice
corrade101111043corrade
corrida1078493corrida
corrie83621213corri_e
corrode101310573corrode
corvid12310473corvid_
corvids1337673corvids
corvine122113643corvine
cosie74728263co_si_e
cosied94819883co_sied
cosine83823513co_sine
cosmid11810643cosmid_
cosmids1237633cosmids
costive12312843costive
coude85022633co__ude
could86517713coul_d_
coulee8323503coul_ee
coulis84018753couli_s
coulisse1045113coulisse
couvade1335063couvade
covelline1446533covelline
covellite1445603covellite
cowhided1843743cowhided
cowhides1735993cowhides
cowled125218383cowled_
cowlick1835263cowlick
cowling134017413cowling
cowpie133511513cowpi_e
cowrie113814273cowri_e
cowrite123612683cowrite
cozie163519123co_zi_e
cozied184112153co_zied
culled94022473culled_
cullies94419963cullies
culling103921303culling
cullion91910233cullion
cullis84115993culli_s
cullises103111313cullises
cultlike1434933cultlike
cuplike1537213cuplike
cutline92914543cutline
cyanide13298843cyanide
cyclize2345403cyclize
dallied93713603dallied
doglike13207453doglike
dolled83518073dolled_
dollies83620983dollies
dolling93817373dolling
dollish11610093dollish
doolie73916833dooli_e
ecocide1246733eco_cide
eellike1138233eellike
elide64922643__elide
folkie13369613folki_e
folklife1842963folklife
folklike1434773folklike
follicle1344393follicle
follies103618943follies
follis93113903folli_s
foxlike21226223foxlike
gallied94114993gallied
gillie74816943gilli_e
gillied95512313gillied
glide74521593__glide
goalie7413153goali_e
godlike1387563godlike
gullied93812063gullied
halide103417993_halide
hillside1254663hillside
hoblike16158303hoblike
hoelike141411163hoelike
hoglike15157733hoglike
hollaed11359853hollaed
hollies103420813hollies
holloed113812753holloed
holytide1544973holytide
hoolie93217773hooli_e
hoplite12311073hoplite
hotline10712343hotline
illite63414923_illite
illude7327503_illude
iodide84812933io_dide
iolite63221983io_lite
jellied15419223jellied
jollier142911003jollier
jollies143516273jollies
jollify2044263jollify
jollily1745773jollily
jollity1746143jollity
joyride1853753joyride
killie104114893killi_e
lolled74315823lolled_
lollies73116923lollies
lolling83415773lolling
lowlife1335143lowlife
millime112511403millime
milline92519113milline
moline84422033mo_line
mollies93420233mollies
mollify1555503mollify
mullite9313013mullite
nellie63614813nelli_e
nonlife1038553nonlife
nuclide1037173nuclide
oblige937653_oblige
occlude1263183occlude
oldie6415473_oldi_e
oleine6313793_oleine
olive84817153_o_live
online6315843_online
onside7511803_onside
oolite63319603_oolite
oreide7311673_oreide
oroide7311703_oroide
owllike1435713owllike
oxide131210953_o_xide
oxlike17307473_oxlike
pallid93915273pallid_
podlike14108553podlike
police102918563po_lice
polite83625073po_lite
polled94022003polled_
pollee83623273poll_ee
pollices12410753pollices
polling102920383polling
pollist9816603pollist
pollute937383pollute
polypide1647013polypide
poolside1145043poolside
potlike13910123potlike
potline91015233potline
rallied83514083rallied
ralline73518413ralline
rodlike1288263rodlike
rolled74220243rolled_
rollick1335613rollick
rolling83620413rolling
roulade856993roulade
sallied83316953sallied
slide64725413__slide
solid65025073so_lid_
solider82912453so_lider
solidi73813153so_lidi
solids74116403so_lids
sonlike112110713sonlike
soullike1236813soullike
sulfide1138103sulfide
sullied83714483sullied
tallied83314753tallied
tillite7313563tillite
toelike11149823toelike
tollage82610163tollage
tolled73819033tolled_
tolling83418563tolling
toluid738213toluid_
toluides935543toluides
toluids835323toluids
topline92313183topline
topside1037733topside
towline102911543towline
toylike14157243toylike
trollied935893trollied
wallie93216803walli_e
wellie92814913welli_e
willie94116453willi_e
willied114611563willied
wolflike1834063wolflike
woolie93514483wooli_e
woollike1534983woollike

Search took 8 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340273666.78319759.3
3Display Results3663660.1232975.6
 (SQL Overall)1786913667.06225303.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.