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

96 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
escheat1241040(None) 
escheats1346251escheats
cheat105732452__cheat
eschar1136522esch_ar
escheated1546272escheated
escheator1464152escheator
eschew1436332esche_w
eschewal1643132eschewal
eschews1534552eschews
estreat7314812estreat
pschent1437412pschent
recheat12415932recheat
archean1269123archean
ascent84519653asc_ent
cachet134526413cache_t
chat95546133__ch_at
cheap126915943__cheap
cheats114519543__cheats
chert105232103__chert
chest104926143__chest
cleat76335063__cleat
descent102616293desc_ent
eche97520283e_che__
eched116919223e_che_d
eches106322163e_che_s
echt95722903e_ch__t
eclat7523603e_c_lat
egghead1343433egghead
enchant12313113enchant
ensheath14133963ensheath
entreat7315263entreat
escalate1039323escalate
escar74011993esc__ar
eschalot1346213eschalot
eschars1237173eschars
escheating1645883escheating
escheators1574193escheators
eschewals1742623eschewals
eschewed1743443eschewed
eschewer1643173eschewer
escolar946053escolar
escort84616483esc_ort
escot75320083esc__ot
esculent1047183esculent
esthete1047433esthete
estreats839423estreats
etchant1249813etchant
etched123613703etche_d
etcher113912943etche_r
etchers123411293etchers
etches114217763etche_s
except1797653exc_ept
excreta1674623excreta
heat77061423___heat
ischia1136393ischia_
ischial1246423ischial
nescient1048713nescient
outcheat1349413outcheat
postheat13411243postheat
preheat12413893preheat
pschents1544113pschents
rachet115028973rache_t
recheats1339193recheats
reheat94423943_reheat
reseat64131493res__eat
richest122813683richest
rochet115423003roche_t
sachet114725773sache_t
scat65848373_sc__at
scent75831623_sc_ent
schav1338313_sch_av
schema1388373_schema
schemas1468163_schemas
schemata1545003_schemata
scheme1379633_scheme
schist11312653_schist
schmear1484043_schmear
schuit1139563_schuit
schwa13426843_schwa_
schwas14396983_schwas
screak125311063_screak
scream104814253_scream
seat47575563_s__eat
secret8325063secre_t
shat76456603_s_h_at
shea76031573_s_hea_
sheaf115424123_s_heaf
sheal84927703_s_heal
shear85424833_s_hear
sheas86331793_s_heas
sheath12412893_s_heath
sheet84836963_s_heet
shent85933503_s_hent
shoat85633953_s_hoat
sweat85628403_s_weat
wheat114924573__wheat

Search took 9 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 Limit134027967.65617506.1
3Display Results96960.0303200.0
 (SQL Overall)178691968.09222082.4
 
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.