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

130 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
syndics133570(None) 
syndic1237301syndic_
cynics13377362cyn_ics
dyadics1453472dyadics
sonics84315632son_ics
syncs104610172syn__cs
syndets1136112syndets
syndical1445372syndical
synodic1347352synodic_
antics84621453_antics
asdics9439863_asdics
bandies104124863bandies
bandits103814793bandits
bindis94614583bindi_s
bonducs1235553bonducs
candids113812693candids
candies104125613candies
conics103920593con_ics
cynic124712423cyn_ic_
dandies94121443dandies
dyadic1336093dyadic_
dynamics1644093dynamics
dyneins1134213dyneins
fanfics1535173fanfics
fundic12389083fundic_
herdics13249523herdics
indices103513443_indices
indict93115563_indict
indicts103210723_indicts
indies73822773_indies
ionics84214473ion_ics
lindies8416583lindies
lyrics11357943ly_rics
manics103919933man_ics
medics114115353_medics
myotics14257593myotics
mystics14279103mystics
nandins8312003nandins
pandies104224503pandies
pandits103914213pandits
panics103815363pan_ics
psychics2043813psychics
pundits10379293pundits
pyknics1842483pyknics
randies84225663randies
rynds9569973rynd__s
sadis64930853s_adi_s
sandals82715203sandals
sanders84025943sanders
sandhis1139993sandhis
sandier84017843sandier
sandiest93218683sandiest
sanding93520603sanding
sandpits1146843sandpits
sands65228583sand__s
sandwich1743653sandwich
sanies63031953san_ies
santims9312593santims
santirs7312963santirs
sardius839553sardius
scandias1137863scandias
scandic1237003scandic_
scenics1137773scenics
sendals81912263sendals
senders83022353senders
sending94221373sending
sends65528243send__s
sendups10115193sendups
sennits73811283sennits
septics112810433septics
sferics1236133sferics
shandies122714103shandies
shindies122610503shindies
shindigs13284203shindigs
sics65234093s___ics
silvics1235563silvics
snails64816653s_nails
snibs75613753s_n_ibs
snick114416013s_n_ick
snicks124312473s_n_icks
snips75818013s_n_ips
snits54124833s_n_its
soddies92312853soddies
sodic84917483s_odic_
sonders83820713sonders
sondes74922873sond_es
sonic75225283son_ic_
sonnies7315223sonnies
spadices1336093spadices
spics94123243s__pics
spondaics1442203spondaics
stadias8411113stadias
statics93314533statics
stoics8311113s_toics
studies82413863studies
studios8256643studios
styptics1543813styptics
sundaes8313093sundaes
sundeck1445273sundeck
sundecks1544253sundecks
sunders84120053sunders
sundews11398153sundews
sundial859863sundial
sundials946753sundials
sundogs947103sundogs
sundries9312023sundries
sylis84316023sy_li_s
sylvins13246243sylvins
sync95415103syn__c_
synch135011793syn__ch
synchs14408453syn_chs
syncing13177223syncing
syncoms1435943syncoms
syndeses1245263syndeses
syndesis1245723syndesis
syndet10311963synd_et
syndetic1446033syndetic_
syndicate1544513syndicate
syndicates1644473syndicates
synesis1039153synesis
syngas10368913syn_gas
synodical1544793synodical
synods1077953syn_ods
synoicous1443003synoicous
synovias1445293synovias
synths12377883syn_ths
tonics83617863ton_ics
tunics83811263tun_ics
undies73821963_undies
wynds126310373wynd__s

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.1731032896.0
2DLD Change Limit1340271307.39018136.3
3Display Results1301300.0462826.1
 (SQL Overall)1786911307.60923484.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.