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

105 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
escuage103511(None) 
escuages1145161escuages
assuage835682assuage
encage93713502enc_age
escape103811662esc_ape
messuage1144522messuage
scutage1036332_scutage
acuate8315633_acuate
arcuate9311963arcuate
assuaged1044383assuaged
assuager944343assuager
assuages936273assuages
asswage1144673asswage
besmudge1442283besmudge
boscage1276533bosc_age
cage75339063__c_age
cubage1178273__cubage
dockage1535723dockage
ecotage1036883ecotage
educate10310213educate
effulge1442473effulge
eluate62315433e_luate
encaged113211083enc_aged
encages103313783enc_ages
encase83714363enc_ase
enchase1239463enchase
enclave1257533enclave
encourage1244153encourage
engage82812103e_ngage
enrage72715073e_nrage
ensilage944713ensilage
equate152012463e_quate
escalade1144383escalade
escalate1039323escalate
escapade1343303escapade
escaped12388853esc_aped
escapee113310463escapee
escaper11368843esc_aper
escapes113811673esc_apes
escar74011993esc_a_r
escarp10449003esc_arp
escars83913133esc_ars
eschar1136533escha_r
eschars1237183eschars
escudo943373escu_do
escudos1043493escudos
esquire16376603esquire
estate64719763es_tate
estrange9488893estrange
estuary1034683estuary
euclase938933euclase
evacuate13217303evacuate
exchange21124323exchange
exclave1945193exclave
excuse1537423excu_se
expunge1743313expunge
fescue1137493fescu__e
incage93513623inc_age
lockage1436613lockage
meshugge1541913meshugge
message1037833mes_sage
messuages1244393messuages
osculate101010613osculate
oscule838193oscu_le
package16128013package
rescale93215473resc_ale
rescuable1347583rescuable
rescue8313003rescu__e
restage83316193res_tage
resurge839073res_urge
sage55044593_s__age
sausage847193_sausage
savage10410173_savage
scag76626893_sc_ag_
scags85520973_sc_ags
scalage103110533_scalage
scale74629143_sc_ale
scape96921843_sc_ape
scare75334463_sc_are
scourge1035653_scourge
scrag85916173_scrag_
scrags95713803_scrags
scrape105917573_scrape
scutages1136503_scutages
scutate9310323_scutate
scute75520943_scu_te
secure8513533secu_re
seepage1037543seepage
selvage1136553selvage
septage1078403septage
serfage1138403serfage
sewage10310733_sewage
silage72715303_silage
sludge84811943_sludge
smudge10387913_smudge
socage91012123_socage
soccage1236283soccage
spurge93711323_spurge
square154513363_square
stage65330193_s_tage
suave83519873_s_uave
surge65027693_s_urge
swage94919563_s_wage
uncage93014873unc_age
usage6410213us__age

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 Limit1340271055.73323378.2
3Display Results1051050.0462282.6
 (SQL Overall)1786911056.18528891.0
 
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.