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

89 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
escheats134625(None) 
escheat12410401escheat_
cheats114519542__cheats
eschars1237172esch_ars
escheated1546272escheated
escheator1464142escheator
escheators1574182escheators
eschewals1742622eschewals
eschews1534552esche_ws
estreats839422estreats
pschents1544112pschents
recheats1339192recheats
ascents93812553asc_ents
cachets145014263cache_ts
chats105730093__ch_ats
cheaps134613683__cheaps
cheat105732453__cheat_
cherts115617233__cherts
chests114916263__chests
cleats84919313__cleats
descents112511203desc_ents
eches106322163e_che__s
eclats8313033e_c_lats
eggheads1442923eggheads
enchants1347823enchants
ensheath14133963ensheath
ensheaths15153133ensheaths
entreats839773entreats
escalate1039323escalate
escalates1148823escalates
escars83913133esc__ars
eschalots1444133eschalots
eschar1136523esch_a_r
escheating1645883escheating
eschew1436333esche__w
eschewal1643133eschewal
eschewed1743443eschewed
eschewer1643163eschewer
eschewers1742873eschewers
escolars1045343escolars
escorts9418403esc_orts
escots84211743esc__ots
esculents1144693esculents
estheses1137783estheses
esthesis1148463esthesis
esthete1047433esthe_te
esthetes1147743esthetes
estreat7314813estreat_
etchants1346023etchants
etchers123411293etche_rs
etches114217763etche__s
excepts1885203exc_epts
heats85838403___heats
nescients1145103nescients
outcheats1445303outcheats
postheats1447433postheats
preheats1339413preheats
pschent1437413pschent_
rachets124516833rache_ts
recheat12415933recheat_
reheats104513523_reheats
reseats74319583res__eats
rochets124213473roche_ts
sachets123914103sache_ts
scats75930603_sc__ats
scents85317023_sc_ents
schavs1436493_sch_avs
schemas1468163_schemas
schemata1545003_schemata
schemes1489663_schemes
schists1248543_schists
schmears1584103_schmears
schnaps1443703_schnaps
schuits1235823_schuits
schwas14396983_schwa_s
screaks13469353_screaks
screams114810613_screams
seats54844343_s__eats
secrets9311773secre_ts
sheafs124912883_s_heafs
sheals94420643_s_heals
shears93820903_s_hears
sheas86331793_s_hea_s
sheath12412893_s_heath
sheaths1358753_s_heaths
sheets93918503_s_heets
shoats94117083_s_hoats
sweats94814613_s_weats
wheats125013223__wheats

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 Filter1786911461620.420425454.8
2DLD Change Limit146162897.20320291.8
3Display Results89890.0332697.0
 (SQL Overall)178691897.65623340.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.