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 “sundeck” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

97 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
sundeck144527(None) 
sundecks1544251sundecks
sneck114713662s_n_eck
sunback1548152sunback
sunder74019822sunde_r
sunders84120052sunders
sundew10369692sunde_w
sundews11398152sundews
undock1337702_undock
asunder856223asunde_r
bedeck1536213_bedeck
burdock1644603burdock
deck115827753___deck
funded114413893funde_d
funder104016083funde_r
funders113813933funders
fundic12389083fundic_
gunlock1444563gunlock
henpeck1843083henpeck
neck105423663__n_eck
nudnick1452863nudnick
pandect12310953pandect
redneck1445113redneck
ruddock1543133ruddock
runback1556603runback
sanded84920613sande_d
sander74828533sande_r
sanders84025943sanders
sended85121233sende_d
sender73824413sende_r
senders83022353senders
seneca839793sen_eca
snack114718063s_n_ack
sneak96016173s_n_eak
snecks124410033s_n_ecks
snick114416013s_n_ick
snuck114411913s_n_uck
sonde64622833sonde__
sonder73623523sonde_r
sonders83820713sonders
sondes74922873sonde_s
sounded93214463sounde_d
sounder83315383sounde_r
sounders93214113sounders
soundest9510973soundest
speck135115653s__peck
subdean1037403subdean
subdeb1137523subde_b
subdebs1236483subdebs
subduce12106983subduce
subduct12107583subduct
subject18258633subject
subsect112611843subsect
suck106131733su___ck
sudden83310833sudde_n
suddens9308783suddens
suede64419753suede__
sueded84014633suede_d
suedes73918113suede_s
sunbeam1146053sunbeam
sunbelt939233sunbelt
sunblock1643763sunblock
sundae7312873sund_ae
sundaes8313093sundaes
sundered10312153sundered
sunderer9310523sunderer
sundial859863sundial
sundog837613sund_og
sundogs947103sundogs
sundown1186313sundown
sundress936983sundress
sundry1057943sund_ry
sunk85031813sun___k
sunken103511783sunke_n
sunket103721363sunke_t
sunkets113511283sunkets
sunless73013693sunless
sunned74216323sunne_d
sunset63723633sunse_t
sunsets72911573sunsets
suspect1158513suspect
syndet10311963synde_t
syndets1136113syndets
syndic1237303syndic_
syndics1335703syndics
uncock1438563_uncock
unde55825483_unde__
undead82711903_undead
undecked16238493_undecked
undee65327273_unde_e
under64624213_unde_r
undocks1436163_undocks
unlock1248533_unlock
unpack1457833_unpack
unpick1446903_unpick
untack1239763_untack
untuck1236403_untuck

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.1561145455.1
2DLD Change Limit134027977.09318895.7
3Display Results97970.0332939.4
 (SQL Overall)178691977.28224538.7
 
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.