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

109 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
syncoms143594(None) 
syncom1336091syncom_
noncoms1139202noncoms
sitcoms1145532sitcoms
synchs14408452sync_hs
syncope1445382syncope
syncopes1545762syncopes
syncs104610172sync__s
synods1077952syn_ods
bancos104713893banco_s
buncos104011593bunco_s
condoms124214083condoms
dynamos1373853dynamos
fandoms13229473fandoms
fantoms12189153fantoms
fynbos1433283fynbo_s
genoms94412483gen_oms
hansoms12238523hansoms
incogs937903_incogs
income10712093_income
incomes11712373_incomes
juncoes16338073juncoes
juncos15449233junco_s
lynches15378873lynches
noms65636403__n_oms
noncom1039683noncom_
rancors9811373rancors
randoms102112433randoms
ransoms92410163ransoms
sanctums1244013sanctums
sanious7514103sanious
sannops936693sannops
santims9312603santims
santols73513323santols
santos64421833santo_s
sarcoma1147403sarcoma
sarcomas1247223sarcomas
sarcous9312933sarcous
scams94423973s__cams
scops95820193s__cops
scots74025913s__cots
scows106617803s__cows
scums95017423s__cums
seccos1039923secco_s
senhors103512133senhors
seniors73413623seniors
senors63620793sen_ors
sensors73514643sensors
shaloms1288983shaloms
shnooks1485583shnooks
sholoms1278033sholoms
simooms1135573simooms
sinuous739063sinuous
sitcom1036903sitcom_
slaloms9106543slaloms
snobs74716153s_n_obs
snogs66017493s_n_ogs
snoods74312453s_noods
snooks104412833s_nooks
snools65715883s_nools
snoops84314173s_noops
snoots64216683s_noots
snots55225123s_n_ots
snows84719893s_n_ows
sodoms989673s_odoms
soms66239373s___oms
succors1137413succors
sunbows1236023sunbows
sundogs947103sundogs
sunrooms1045723sunrooms
syboes1139343sy_boes
sycees11409653sy_cees
syces106416463sy_c_es
sycoses1249133sy_coses
sycosis1238823sy_cosis
symbols1435523symbols
symptoms1743763symptoms
synagogs1343273synagogs
synanons1144633synanons
sync95415103sync___
syncarp1444533syncarp
syncarps1543903syncarps
synced12266963sync_ed
synch135011793sync__h
synched16277213synched
synchro1544543synchro
synchros1645203synchros
syncing13177223syncing
syncopal1544073syncopal
syncopic1745633syncopic
syndets1136113syndets
syndics1335703syndics
syndrome1444293syndrome
syndromes1544503syndromes
synesis1039163synesis
syngamy1643113syngamy
syngas10368913syn_gas
synod9610283syn_o_d
synoicous1443003synoicous
synonyms1643893synonyms
syntagms1442723syntagms
synths12377883syn_ths
syntony1344523syntony
syphons1537503syphons
sysops1136013sy_sops
systems1234683systems
uncos74117033_unco_s
venoms114211213ven_oms
zincous1837053zincous

Search took 7 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.406440125.6
2DLD Change Limit1340271096.25021444.3
3Display Results1091090.0303633.3
 (SQL Overall)1786911096.68626726.1
 
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.