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

117 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
sonicate1031093(None) 
sonicated1248451sonicated
sonicates11410381sonicates
fornicate1446082fornicate
loricate10310662loricate
sanitate8612042sanitate
silicate10312622silicate
sonicator1197262sonicator
spicate113214192s_picate
suricate10312612suricate
syndicate1544512syndicate
tunicate103310042tunicate
abdicate1348903abdicate
animate91617213_animate
boniato947283boni_ato
boniface1543863boniface
cogitate1148553cogitate
coinmate1239063coinmate
colocate12313443colocate
concave1439373con_cave
conepate12712533conepate
confiscate1744403confiscate
conflate13311173conflate
conical11316203conica_l
conicity15411093conicity
connate9315753con_nate
corticate13410763corticate
dedicate12312803dedicate
delicate11315493delicate
dominate11312853dominate
donate73619503don__ate
foliate10513533foli_ate
forficate1745123forficate
fornicated1644823fornicated
fornicates1545843fornicates
gonocyte1454873gonocyte
indicate11313353indicate
iodinate949343iodinate
ionicity1348823ionicity
locate83919843lo__cate
loricae938253lorica_e
loricated1247893loricated
loricates11310123loricates
medicate13513243medicate
meniscate1346223meniscate
monocyte1547893monocyte
motivate1347693motivate
muricate12311113muricate
nictate9310223__nictate
nidate7313783__nidate
nominate10312473nominate
nonimage1144883nonimage
noviciate1444423noviciate
ocicat101412813_ocicat_
ocicats11137413_ocicats
opiate8513463_opi_ate
oxidate1537023_oxidate
plicate11314513_plicate
radicate11412873radicate
saccate111311763s_accate
salivate11310013salivate
sanicle91210263sanic_le
sanitated1068993sanitated
sanitates9611733sanitates
satiate7315403sati_ate
senate63725173sen__ate
sensate7311893sen_sate
seriate73722473seri_ate
sibilate1049533sibilate
silicates11311523silicates
sinicize1947333sinicize
sinuate7412163sin_uate
snowcat1245333snowcat_
snowcats1343413snowcats
socage91012123so__cage
soccage1236283so_ccage
soilage8169353so_ilage
solate64526073so__late
solicit9315743solicit_
solicited1247973solicited
solicits10311023solicits
solvate102710213so_lvate
somite84519373somi__te
sonata6313223son__ata
sonic75225293sonic___
sonically14310953sonically
sonicating1348313sonicating
sonication12411183sonication
sonicators1277063sonicators
sonics84315633sonic__s
sopite84917713sopi__te
sorbate9311733so_rbate
soricine10710883soricine
sororate8411173sororate
soulmate1047193soulmate
speciate12209583speciate
spicae104313703s_pica_e
spicated13309903s_picated
spinate93114813s_pinate
spoliate1039243spoli_ate
striate74218953stri_ate
sulcate9314423s_ulcate
supinate10310313supinate
suricates11311743suricates
syndicated1743743syndicated
syndicates1644473syndicates
toccate1138773to_ccate
tonicity1348543tonicity
tunicae9328143tunica_e
tunicated12257493tunicated
tunicates11268743tunicates
urticate1049863urticate
vesicate131210053vesicate
vindicate1546353vindicate
vomicae1445303vomica_e
zincate1838533zin_cate
zonate154114923zon__ate

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 Filter1786911461620.453394461.4
2DLD Change Limit1461621177.50019488.3
3Display Results1171170.0462543.5
 (SQL Overall)1786911177.99922339.2
 
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.