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

114 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
syncom133609(None) 
syncoms1435941syncoms
noncom1039682noncom
sitcom1036902sitcom
sync95415102sync__
synced12266962synced
synch135011792sync_h
synchs14408452synchs
syncope1445382syncope
syncs104610172sync_s
synod9610282syn_od
ancon75718233_ancon
banco94019393banco_
bancos104713893bancos
bunco94616083bunco_
buncos104011593buncos
condom114215363condom
dynamo1274163dynamo
fandom122110893fandom
fantom112110803fantom
fynbos1433283fynbos
genom83716843gen_om
hansom11219153hansom
incog838253_incog
income10712093_income
junco144612203junco_
juncos15449233juncos
lynch13468983lync_h
nom510450643__n_om
noncoms1139203noncoms
rancor8810373rancor
random92513553random
ransom82410943ransom
sancta839833sancta
sanctum1145293sanctum
sannop837373sannop
santo56227283santo_
santol64515243santol
santos64421833santos
sarcoma1147403sarcoma
scam85932353s__cam
scop85925523s__cop
scot66242613s__cot
scow96021423s__cow
scum85924523s__cum
secco9312423secco_
seccos1039923seccos
seldom939413seldom
senhor93010813senhor
senior63214053senior
senor53822803sen_or
sensor63813843sensor
sensum849353sensum
shalom11810923shalom
shnook1366343shnook
sholom11910113sholom
simoom1037503simoom
since75024173sinc_e
sitcoms1145533sitcoms
slalom888173slalom
snob65825593s_n_ob
snog55623633s_n_og
snood64616163s_nood
snook95115573s_nook
snool55118643s_nool
snoop75317173s_noop
snoot55030143s_noot
snot44745453s_n_ot
snow76324793s_n_ow
sodom8814913s_odom
som59153813s___om
succor1036623succor
sunbow1145823sunbow
sundog837613sundog
sunroom947013sunroom
sybo9714743sy_bo_
syce95820283sy_c_e
sycee105018623sy_cee
syces106416463sy_ces
symbol1336083symbol
symptom1644003symptom
syn67024123syn___
synagog1243623synagog
synanon1044743synanon
syncarp1444533syncarp
synched16277213synched
synchro1544543synchro
synchros1645203synchros
syncing13177223syncing
syncopal1544073syncopal
syncopes1545763syncopes
syncopic1745633syncopic
syndet10311963syndet
syndic1237303syndic
syndrome1444293syndrome
syne75725763syn__e
syngamy1643113syngamy
syngas10368913syngas
synods1077953synods
synonym1544073synonym
syntagm1343313syntagm
syntax1634303syntax
synth113711823syn_th
synths12377883synths
syntony1344523syntony
synura935983synura
syphon1436853syphon
sysop1037193sy_sop
system1135743system
unco66021403_unco_
uncos74117033_uncos
uncoy104111413_uncoy
venom103914863ven_om
yom88043443_y__om

Search took 6 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 Filter1786911127160.376475242.0
2DLD Change Limit1127161145.22021593.1
3Display Results1141140.0462478.3
 (SQL Overall)1786911145.64231671.6
 
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.