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

190 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
desserts924792(None) 
deserts82513051de_serts
dessert82916451dessert_
disserts92411811disserts
asserts74311792_asserts
descents112511202descents
desert72725492de_sert_
disseats93211502disseats
dissects11279242dissects
dissents93411862dissents
dissert83720692dissert_
dosserets10145692dosserets
dossers84516232dosser_s
dressers9359862dresser_s
exserts1467012_exserts
reasserts945982reasserts
assents74512223_assents
assert64922573_assert_
assets65617663_asse_ts
assorts73310153_assorts
bassets96414823basse_ts
bassetts10407373bassetts
berserks1433993berserks
besets85718803be_se_ts
blessers10277623blesser_s
censers94313903censer_s
cesses84221363cesse__s
cesspits1243663cesspits
cossets95014283cosse_ts
cressets10309103cresse_ts
cussers94213393cusser_s
dashers115016863dasher_s
dealers84118613dealer_s
debasers11377903debaser_s
deceits102810883de_ceits
decerns10119053de_cerns
deckers144413833decker_s
deers64930523de__er_s
deets65330243de__e_ts
defeats113511233de_feats
defects134511523de_fects
defers105116943de_fer_s
defiers113913993defier_s
deflects14336733deflects
defusers12487363defuser_s
degassers11354833degasser_s
degerms1135623de_germs
dehorts11379773de_horts
deicers103612733deicer_s
deists74916433deis__ts
dejects17389223de_jects
delvers113411993delver_s
dements103016623de_ments
demerits11310763de_merits
deniers84515183denier_s
denser74115193denser__
densest83112473densest_
departs104310683de_parts
deperms1236603de_perms
deports105012883de_ports
deposers11359243deposer_s
desalts839573de_salts
descants112910143descants
descends12266983descends
descent102616293descent_
deselects1244493deselects
deserted101012203de_serted
deserter91211603de_serter
deserters10129983de_serters
desertic1147743de_sertic
deserve11108703de_serve
deserves12109893de_serves
desexes1537833de_sexes
desirers939263desirers
desires81316133de_sires
desists83611723de_sists
desorbs10437713de_sorbs
desperate12410833desperate
despisers1245153despiser_s
despots10319683de_spots
detects104011093de_tects
detents83615153de_tents
deters74724683de_ter_s
detests83711743de_tests
devests114410473de_vests
devisers12339863deviser_s
diesters92513593diester_s
discepts1336743discepts
discerns1138163discerns
disherits1348233disherits
disjects18275923disjects
disparts11109953disparts
disports111111113disports
disseat83816923disseat_
dissect103614133dissect_
dissent84018683dissent_
disserted11109803disserted
disserve1287443disserve
disserves1388063disserves
disses75225963disse__s
distorts91112343distorts
diverts114412033d_iverts
dorsers83516293dorser_s
dosers75723633d_oser_s
dossels85511603dosse_ls
dosser74417973dosser__
dosseret91111513dosseret
dosses76126273dosse__s
dossiers9318043dossier_s
dousers84817273douser_s
dowsers115013523dowser_s
dresser83611953dresser__
dresses83716173dresse__s
droseras935873droseras
dusters84918353duster_s
enserfs1035483_enserfs
escorts9418403_escorts
eskers105312223_esker_s
esses56422973_esse__s
esters64627733_ester_s
everts94514893_e_verts
exerts133712293_e_xerts
experts1659063_experts
exsects1655573_exsects
exsert13414363_exsert_
fesses94820253fesse__s
festers104121393fester_s
fussers104210813fusser_s
gassers84714633gasser_s
geysers1135703geyser_s
guessers9174893guesser_s
gussets837443gusse_ts
hissers104112313hisser_s
inserts74013993_inserts
jesses135215953jesse__s
jesters144118193jester_s
keysets1434343keyse_ts
kissers114211293kisser_s
knessets1243173knesse_ts
leasers74717843leaser_s
lessees73510243lesse_es
lessens7409383lesse_ns
lesser63514853lesser__
lessors73610523lessor_s
messes84924343messe__s
misseats104011683misseats
missets94516573misse_ts
missorts1038323missorts
mossers94116193mosser_s
nesses64718323nesse__s
nesters74422783nester_s
outserts8309803outserts
passers94717753passer_s
perverts1337523perverts
pesters93827093pester_s
pissers95014753pisser_s
possets94212773posse_ts
pressers103215023presser_s
reassert8313673reassert_
reassorts945623reassorts
reinserts946423reinserts
reseats74319583re_seats
resects94115593re_sects
resents74221223re_sents
resets65427613re_se_ts
resmelts1046143resmelts
resorts74817193re_sorts
respects1247703respects
restarts8310873restarts
resters74130403rester_s
reverts104715043re_verts
russets738163russe_ts
seisers73816393seiser_s
sestets7911473seste_ts
tassets75012773tasse_ts
teasers75317243teaser_s
tessera736333tesser_a
tesseracts1251583tesseracts
tesserae844793tesserae
testers74124543tester_s
tossers74713493tosser_s
tussers74313563tusser_s
versers103813513verser_s
versets103913093verse_ts
vespers1239033vesper_s
vessels1035933vesse_ls
westerns11328963westerns
westers105221963wester_s
yesses93615813yesse__s
zesters163517293zester_s

Search took 10 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.343520965.0
2DLD Change Limit1461621908.83016552.9
3Display Results1901900.0762500.0
 (SQL Overall)1786911909.24919320.0
 
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.