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

217 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
recheat1241593(None) 
recheats1339191recheats
reheat94423941re_heat
cheat105732452__cheat
escheat12410412escheat
preheat12413892pre_heat
rachet115028972rache_t
recent83630852rec_ent
recept103319072rec_ept
rechart12314332rechart
recheck1835612recheck
rechew14310212reche_w
rechews1537292rechews
reclean938522reclean
recoat84024272rec_oat
recreant10311282recreant
recreate10313602recreate
redhead1257052redhead
rehear93713222re_hear
reheats104513522re_heats
repeat85127212re_peat
reseat64131492re_seat
retreat7317532retreat
richest122813682richest
rochet115423002roche_t
archean1269123archean
becket144619883becke_t
behead1239923be_head
behest11314613be_hest
brachet144020313brache_t
brecham1646833brech_am
brechan1437223brech_an
cachet134526413cache_t
chat95546133__ch_at
cheap126915943__cheap
cheats114519543__cheats
chert105232103__chert
chest104926143__chest
cleat76335063__cleat
creche13310763creche__
creches14313093creche_s
crochet143616663croche_t
deceit93018213dec_eit
decent94023703dec_ent
defeat103817163de_feat
eche97520283_eche__
eched116919223_eche_d
eches106322163_eche_s
echt95722903_ech__t
eclat7523603_ec_lat
escheats1346253escheats
freshest143010583freshest
freshet133416643freshe_t
heat77061423___heat
hereat93527413he_reat
leched123716003leche_d
lecher113415853leche_r
lechers123313963lechers
lechery15257643lechery
leches115421313leche_s
lethean1037093lethean
outcheat1349413outcheat
overheat142413773overheat
pechan13511543pech_an
peched144915343peche_d
precent113520263prec_ent
precept133112513prec_ept
precheck2144153precheck
preclean1245893preclean
preclear1245423preclear
preheats1339413pre_heats
pretreat10311923pretreat
pschent1437413pschent
rachets124516833rachets
rachial122012173rachial
raciest92820013raciest
racket125229423racke_t
rashest103916873rashest
ratchet124218333ratche_t
reaccent1278573reaccent
reaccept1465123reaccept
reached134619083reache_d
reacher123718293reache_r
reachers133515723reachers
reaches123423203reache_s
reagent8716603reagent
realest73322433realest
reblent9614253reblent
recant83228683rec_ant
recap95718023rec__ap
recast83422773rec_ast
recce9514563recce__
recces10614913recce_s
recede95515533rec_ede
receipt1159253receipt
recement12315653recement
recepts113010263rec_epts
recess8314263rec_ess
recharts1337663recharts
rechecks1944553rechecks
rechewed1735633rechewed
rechose121312043rechose
recit75235103rec__it
recital9412163recital
recked134821803recke_d
reclad9311873rec_lad
recleans1037513recleans
recoal84117973rec_oal
recoats92616643rec_oats
recount9315173recount
recrate92621663rec_rate
recreants1146623recreants
recreated12412533recreated
recreates11313363recreates
recruit939773recruit
recta74220263rec_ta_
rectal84418133rec_tal
recusal968673recusal
recusant1049463recusant
recut74729243rec__ut
redcoat10410883redcoat
reddest9311953reddest
redear73515173re_dear
redefeat1246313redefeat
redheads1336173redheads
redream10107913redream
redreamt11127183redreamt
reechiest1446013reechiest
reeject16349623reeject
reelect911515633reelect
reerect92915883reerect
reest54938093re__est
refect114319333re_fect
refelt94521423re_felt
reflect123913713reflect
reflet94024233refle_t
refloat10310833refloat
regear73512743re_gear
regent74127673re_gent
reglet73724233regle_t
regreet83015953regreet
regret73723533regre_t
rehab10312443re_h_ab
reheard11309023re_heard
rehears103312773re_hears
reheated122415003re_heated
reheater113413033re_heater
reheel93610823re_heel
rehem103815353re_he_m
rehems113410983re_hems
reject154116283re_ject
relent64431853re_lent
relet54749823re_le_t
remeet86325473re_meet
remelt85123123re_melt
remet74843723re_me_t
renest64529713re_nest
rennet64624853renne_t
repeal84718283re_peal
repeats94316053re_peats
repent84728873re_pent
replead10399013replead
request16311023request
reread71715433re_read
rerent63832453re_rent
rerepeat1047953rerepeat
resat55139683re__sat
reseal64819643re_seal
reseats74319583re_seats
reseau64216213re_seau
resect84424703re_sect
resent63833623re_sent
reset55051863re_se_t
reshes94124363reshe_s
reshoot102513893reshoot
reshot93519633resh_ot
resmelt9411773resmelt
respeak1335933respeak
respect11412033respect
respelt9312143respelt
retched133814273retche_d
retches123318513retche_s
reteam83214533re_team
retear63115483re_tear
retest64028453re_test
rethread1245353rethread
retread849003retread
retreats8311413retreats
reveal94115053re_veal
revehent14239083revehent
revert93529113re_vert
revest94623603re_vest
revet84938843re_ve_t
rewear93012003re_wear
rewet85135153re_we_t
rhea75017433r__hea_
rheas84816953r__heas
richen113812513riche_n
richens12349733richens
richer114015043riche_r
riches115022083riche_s
rochets124213473rochets
rocket125425283rocke_t
ruche104216763ruche__
ruched124314633ruche_d
ruches114819583ruche_s
sachet114725773sache_t
secret8325063secre_t
teched124014433teche_d
techiest1359833techiest
trachea12311683trachea_
tracheae1349113tracheae
tracheal1348253tracheal
tracheas13410273tracheas
tracheate1448233tracheate
wecht13415443wech__t
wheat114924573__wheat

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 Filter1786911340270.420425454.8
2DLD Change Limit1340272176.81319672.2
3Display Results2172170.0802712.5
 (SQL Overall)1786912177.31324434.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.