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

117 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
dressings1126537(None) 
dressing102810421dressing_
pressings12269021pressings
blessings1233722blessings
crestings12298042crestings
crossings12217162crossings
dredgings13252952dredgings
dressiness1145542dressiness
pressing112516442pressing_
trussings10224032trussings
addressing1343133addressing_
beestings12335923beestings
beeswings15293303beeswings
biestings12266033biestings
blessing1137593blessing_
brassing112612303brassing_
breakings16297063breakings
breedings13375763breedings
brewings14296693bre_wings
brislings12236363brislings
bussings11386663_bussings
caressing1238803caressing_
cessing103814813_cessing_
creasing113314443creasing_
cresting114017043cresting_
crossing112612683crossing_
cruisings12214113cruisings
dealings103510703d_ealings
deckings16346683d_eckings
depressing1448093depressing_
designs9328313d_e_signs
destines93619663d_estines
dieselings1252933dieselings
digressing1345793digressing_
dissing94517683d_issing_
doeskins1344903doeskin_s
dossing93313273d_ossing_
draftings14334203draftings
drawings13386283dr_awings
dreading113712803dreading_
dreaming124011063dreaming_
dredging12236423dredging_
dreeing94311183dre_eing_
dressage1044253dress_age
dressages1144153dressages
dressers9359863dress_ers
dresses83716173dress__es
dressier956863dressi_er
dressiest1036823dressiest
dressily1246443dressi_ly
dressmakings2051433dressmakings
drillings11285823drillings
drinkings15244773drinkings
drippings15313903drippings
drivings13265763dr_ivings
droppings15264503droppings
drowsing13287773drowsing_
drubbings15262883drubbings
dustings10419033d_ustings
dwellings14244213dwellings
dyeings12374643dye__ings
egressing1146853egressing_
erepsins1037443erepsin_s
fessing113812863_fessing_
fleshings16335383fleshings
freshing152611023freshing_
frostings1335733frostings
gassings10438403_gassings
grassing103311973grassing_
greasing102811393greasing_
greenings11266663greenings
greetings11276043greetings
grossing103111063grossing_
guessing1036243guessing_
hissings12556753_hissings
jessing153710623_jessing_
jestings16368023_jestings
leasings9379843_leasings
messing103916393_messing_
passings11409873_passings
preassigns1343553preassigns
prescinds1444953prescinds
pressgangs1452283pressgangs
pressingly1646003pressingly
prissing113011453prissing_
raisings9338443_raisings
raspings11337853_raspings
readings103512643_readings
reassigns1074353_reassigns
redressing1247823redressing_
redwings13305733_redwings
reedings103510363_reedings
reelings94012563_reelings
rescinds1136333_rescinds
reshines112615443_reshines
resigns83910963_re_signs
resins64528773_re_sin_s
resprings12156253_resprings
resting85031183_resting_
restrings10159293_restrings
retsinas8387963_retsinas
reusing82516783_reusing_
rieslings1034493rieslings
rinsings9318013_rinsings
risings83211893_r_isings
rushings12387843_rushings
seisings9398523_seisings
stressing1038333stressing_
topdressings1651443topdressings
trussing9268653trussing_
undressing1246533undressing_
vestings12359143_vestings
westings12429803_westings
wreckings19233683wreckings
wresting123811833wresting_
wrestlings1442933wrestlings
yessing113210063_yessing_

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411176.43623095.2
3Display Results1171170.0462543.5
 (SQL Overall)1786911176.90225889.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.