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

144 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
silicate1031262(None) 
silicates11311521silicates
ciliate9514602cili_ate
delicate11315492delicate
filiate10414232fili_ate
militate10311672militate
plicate11314512_plicate
salivate11310012salivate
sibilate1049532sibilate
silica8311242silica__
silicas9310602silica_s
silicide1147832silicide
silicle937752silic_le
silicone1096732silicone
sonicate10310932sonicate
spicate113214192s_picate
sulcate9314422sul_cate
suricate10312612suricate
abdicate1348903abdicate
allocate10411023allocate
basilicae1343123basilica_e
bilobate1247033bilobate
califate13310483califate
calycate1537893calycate
celibate1259313celibate
ciliated11510953cili_ated
ciliates10413453cili_ates
cilice103213353cilic__e
ciliolate1145973ciliolate
climate11312833_climate
colocate12313433colocate
dedicate12312803dedicate
delicates12314313delicates
digitate1098683digitate
dilatate947773dilatate
dilate73220693dil__ate
dislocate1289133dislocate
duplicate1447003duplicate
explicate20117493explicate
falcate12311613fal_cate
filiated12610083fili_ated
filiates11412663fili_ates
filicide1446363filicide
filtrate1148223filtrate
foliate10513533foli_ate
imitate9310873_imitate
implicate1547273implicate
indicate11313353indicate
kalifate1556493kalifate
ligate72519253__ligate
litigate948303litigate
locate83919843__locate
loricate10310663loricate
medicate13513243medicate
militated1248803militated
militates11310883militates
millcake1644653millcake
mislocate13107713mislocate
mitigate1148693mitigate
muricate12311113muricate
obligate11198303obligate
pileate93815923pil_eate
placate11312433_placate
plicae10410953_plica_e
plicated13310643_plicated
radicate11412873radicate
relocate10713533relocate
replicate13410043replicate
saccate111311763s_accate
salicine10311703salicine
salicylate1552983salicylate
salivated1337473salivated
salivates1239293salivates
sanitate8612043sanitate
satiate7315403sati_ate
scilicet1249543scilicet_
selenate81712523selenate
seriate73722473seri_ate
sibilated1246713sibilated
sibilates1148443sibilates
sigmate10710143si_gmate
silage72715303sil__age
silane62718053sil__ane
silicic1147603silic_ic
silicides1247073silicides
silicify1644273silicify
silicium1286563silicium
silicles1037073silicles
silicon9117533silic_on
silicones11106553silicones
silicons10107163silicons
silicoses1186183silicoses
silicotic1344303silicotic
silicula1065393silicula
siliculae1154283siliculae
siliquae1743233siliquae
silique1645643sili_que
siloxane1543743siloxane
silvae92811093sil_va_e
silvical1345223silvica_l
simulate10311133simulate
sinicize1947333sinicize
sinuate7412163si_nuate
situate7410783si_tuate
slate55438283s_l__ate
slice74925823s_lic__e
slipcase1263923slipcase
solate64526073sol__ate
solicit9315743solicit_
solicited1247973solicited
solicits10311023solicits
solvate102710213sol_vate
sonicated1248453sonicated
sonicates11410383sonicates
speciate12209583speciate
spicae104313703s_pica_e
spicated13309903s_picated
spinate93114813s_pinate
splice104915103splic__e
spoliate1039243spoli_ate
stipitate1144613stipitate
striate74218953stri_ate
sublimate1347433sublimate
sulcated11310373sul_cated
sulfate10311653sul_fate
sulphate1346643sulphate
supinate10310313supinate
supplicate1644523supplicate
suricates11311743suricates
syndicate1544513syndicate
titivate1146803titivate
triplicate1445323triplicate
tunicate103310043tunicate
umbilicate1653043umbilicate
urticate1049863urticate
validate1239003validate
vellicate1446433vellicate
vesicate131210053vesicate
vindicate1546353vindicate
vitiate103412953viti_ate
vizirate2045353vizirate
wildcat1346293wildcat_
wildcats1444173wildcats
zincate1838533zi_ncate

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621446.69021847.8
3Display Results1441440.0602400.0
 (SQL Overall)1786911447.17024922.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.