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

219 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
collating1231278(None) 
collaging1337931collaging
collaring12310561collaring
colleting12311061colleting
cellaring1238532cellaring
chelating1549362chelating
cleating113518142c_leating
coating103525312co__ating
coleading1338522coleading
collapsing1543832collapsing
collation11313992collation
collations12312852collations
collecting1548282collecting
colliding1338582colliding
colligating1545712colligating
collimating1645432collimating
collocating1645912collocating
colluding1335902colluding
collying14319552coll_ying
colocating1548622colocating
combating16310162combating
conflating16410002conflating
copulating1549372copulating
corelating13511582corelating
decollating1545972decollating
fellating1339252fellating
foliating1339252foliating
hollaing12167102holla_ing
polluting1235702polluting
solating9315592so_lating
solvating1336442solvating
ablating11312003_ablating
acylating1547573acylating
adulating1178723adulating
allaying12339313_allaying
ballasting1345303ballasting
balloting1238393balloting
billeting1236643billeting
bleating113514503_bleating
bloating113512813_bloating
boating103721303bo__ating
bolling103820883boll__ing
bollixing1944813bollixing
bolloxing1944773bolloxing
bolting104416763bo_l_ting
borating113414503bo_rating
bulleting1236643bulleting
calculating1666793calculating
calling103826773call__ing
callusing1236173callusing
canulating1349553canulating
caseating12311743caseating
caveating1539293caveating
celling103921263cell__ing
cheating144014523c_heating
clawing133812673c__lawing
claying133614303c__laying
cleaning113112383c_leaning
clearing113014883c_learing
cleaving141389683c_leaving
clefting14347583c_lefting
cloaking15299713c_loaking
closeting1236183closeting
clotting113110643c_lotting
clouting113011683c_louting
coacting133412703co_acting
coagulating1545073coagulating
coaling103722823co__aling
coaming123818323co__aming
coapting133511613co_apting
coasting113615513co_asting
coatings113811843co__atings
coaxing173511703co__axing
cobaltine13135613cobaltine
cocreating15310293cocreating
codling114418953codl__ing
coediting1338333coediting
coempting1636073coempting
coenacting1545873coenacting
coequating2245323coequating
cogitating1447213cogitating
coheading1636623coheading
cohobating1845023cohobating
cohosting1546323cohosting
coiling103723453coil__ing
colistin10410553colistin_
colistins1149233colistins
collagen11338583collagen_
collagens12256043collagens
collagist1248023collagist
collate92919683collat__e
collated113615063collat_ed
collates103019143collat_es
collator10310373collat_or
collators11410343collators
collins93419833coll__ins
colloguing1444553colloguing
coloring11414843co_loring
colouring1258733colouring
comaking1739993co_making
combatting1755143combatting
commuting16288443commuting
compacting19177093compacting
comparing162410583comparing
comparting17188383comparting
competing163712463competing
completing1748423completing
compting153013603co_mpting
computing16309853computing
concaving1737353concaving
confuting1539093confuting
congaing1239823conga_ing
connoting12310023connoting
contacting15610073contacting
cooling103422573cool__ing
coopting133411313co_opting
coplotting1555953coplotting
coronating13410173coronating
corotating1349323corotating
corrading1338203corrading
correlating1487083correlating
corseting12312173corseting
cosseting1239543cosseting
costing104323023co__sting
coting94629253co___ting
counting113115273co_unting
courting112514573co_urting
coveting141912303co_veting
cowling134017423cowl__ing
cowriting1557323cowriting
crating103725203c__rating
creating113921953c_reating
cremating14312203cremating
culling103921303cull__ing
cullying14297503cull_ying
cumulating1546353cumulating
curating11314293c_urating
deflating142610713deflating
delating103119603_delating
dilating102714913_dilating
doating93816863do__ating
dolling93817373doll__ing
dolloping1344993dolloping
dollying13407423doll_ying
donating10311803do_nating
elating83423083__elating
emulating1239873emulating
epilating12310973epilating
filiating1339253filiating
filleting1335853filleting
floating123111883_floating
following1665753following
gallanting1245353gallanting
galleting1137633galleting
gelating103015733_gelating
gloating102611463_gloating
hollering1337743hollering
holloaing1385803holloaing
holloing12148823holl_oing
hollooing1385363hollooing
hollowing1675933hollowing
inflating13310443inflating
iodating1038823io_dating
isolating1039743isolating
jollying19316063joll_ying
jolting153410913jo_l_ting
locating11311503lo_cating
lolling83415783loll__ing
lolloping1244693lolloping
moating104218153mo__ating
modulating1446373modulating
molesting1237753molesting
molting103517173mo_l_ting
moulting112710313moul_ting
notating92513343no_tating
opiating11410093_opiating
orating83520323_o_rating
oscillating1443983oscillating
ovulating1336953ovulating
oxalating1745803oxalating
palleting1238743palleting
palliating1347893palliating
palpating1438543palpating
pelleting1237953pelleting
pillaging1345573pillaging
pillaring1237653pillaring
plating103823073__plating
pleating112916053_pleating
poleaxing1944873poleaxing
polkaing1534633polka_ing
pollarding1444243pollarding
pollenating1444563pollenating
pollening1236923pollening
pollinating1445623pollinating
polling102920383poll__ing
populating1547663populating
pulsating1236343pulsating
reflating132514713reflating
relating92725443_relating
replating122217403replating
reslating102516993reslating
rolling83620413roll__ing
rotating92614553ro_tating
scolloping1543243scolloping
slating83724653__slating
solacing11310133so_lacing
spoliating1366963spoliating
sublating12310983sublating
sulfating1338063sulfating
tallaging1146503tallaging
toileting1036263toileting
tolerating1148593tolerating
tolling83418563toll__ing
ululating1036643ululating
vacillating1744623vacillating
valuating1338653valuating
violating1337443violating
volleying1643763volleying
volplaning1642473volplaning

Search took 9 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 Filter1786911486410.423422437.4
2DLD Change Limit1486412197.59319576.1
3Display Results2192190.1101990.9
 (SQL Overall)1786912198.12621990.0
 
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.