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

177 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
recheats133919(None) 
recheat12415931recheat_
reheats104513521re_heats
cheats114519542__cheats
escheats1346252escheats
preheats1339412pre_heats
rachets124516832rache_ts
recepts113010262rec_epts
recharts1337662recharts
rechecks1944552rechecks
rechews1537292reche_ws
recleans1037512recleans
recoats92616642rec_oats
recreants1146622recreants
recreate10313602recreate
recreates11313362recreates
redheads1336172redheads
rehears103312772re_hears
reheat94423942re_heat_
repeats94316052re_peats
reseats74319582re_seats
retreats8311412retreats
rochets124213472roche_ts
beckets15399823becke_ts
beheads1338523be_heads
behests1235953be_hests
brachets154311983brache_ts
brechams1745773brech_ams
brechans1547413brech_ans
cachets145014263cache_ts
chats105730093__ch_ats
cheaps134613683__cheaps
cheat105732453__cheat_
cherts115617233__cherts
chests114916263__chests
cleats84919313__cleats
creches14313093creche__s
crochets15359833croche_ts
deceits102810883dec_eits
defeats113511233de_feats
eches106322163_eche__s
eclats8313033_ec_lats
escheat12410403escheat_
freshets14298673freshe_ts
heats85838403___heats
lechers123313963leche_rs
leches115421313leche__s
outcheats1445303outcheats
overheats15229993overheats
pechans14810503pech_ans
precents123015043prec_ents
precepts14268893prec_epts
prechecks2243573prechecks
precleans1344893precleans
preclears1344373preclears
preheat12413893pre_heat_
pretreats1146933pretreats
pschents1544113pschents
rachet115028973rache_t_
rackets134916873racke_ts
ratchets133110263ratche_ts
reaccents1365853reaccents
reaccepts1583213reaccepts
reachers133515723reache_rs
reaches123423203reache__s
reagents959623reagents
recants93217093rec_ants
recaps103615733rec__aps
recast83422773rec__ast
recasts93413533rec_asts
recces10614913recce__s
recedes102816063rec_edes
receipts1274693receipts
recements13312283recements
recent83630853rec_ent_
recept103319073rec_ept_
recess8314263rec_e_ss
rechart12314323rech_art
recheck1835613reche_ck
rechew14310213reche__w
rechewed1735633rechewed
recitals1039763recitals
recits83621353rec__its
reclads1049993rec_lads
reclean938523reclea_n
recoals94214623rec_oals
recoat84024273rec_oat_
recounts1038773recounts
recrate92621663rec_rate
recrates102420373rec_rates
recreant10311283recreant
recreated12412533recreated
recruits1036563recruits
recusals1056393recusals
recusants1145103recusants
recuts83817373rec__uts
redcoats1147123redcoats
redears82814453re_dears
redefeats1344203redefeats
redhead1257053redhea_d
redreams1195953redreams
reejects17336083reejects
reelects103110883reelects
reerects10319923reerects
reests64618893re__ests
refects124012743re_fects
reflects13288873reflects
reflets103513153refle_ts
refloats1156913refloats
regears83012463re_gears
regents83416543re_gents
reglets83512983regle_ts
regreets9287853regreets
regrets83212923regre_ts
rehabs1139023re_h_abs
rehear93713223re_hea_r
reheard11309023re_heard
rehearse11296653re_hearse
reheated122415003re_heated
reheater113413033re_heater
reheaters122010273re_heaters
reheels10298253re_heels
rehems113410983re_he_ms
rejects163910693re_jects
relents74018503re_lents
relets64025673re_le_ts
remeets93712413re_meets
remelts93511493re_melts
renests74014213re_nests
rennets75212633renne_ts
repeals94014523re_peals
repeat85127213re_peat_
repents93717623re_pents
repleads11357213repleads
requests1735743requests
rereads81512293re_reads
rerents73319423re_rents
rerepeats1145263rerepeats
reseals73917663re_seals
reseat64131493re_seat_
reseaus74012153re_seaus
resects94115593re_sects
resents74221223re_sents
resets65427613re_se_ts
reshes94124363reshe__s
reshoots11228413reshoots
resmelts1046143resmelts
respeaks1434953respeaks
respects1247703respects
retches123318513retche__s
reteams9339563re_teams
retears72814923re_tears
retests73813853re_tests
rethreads1344483rethreads
retreads937823retreads
retreat7317533retreat_
reveals103812723re_veals
reverts104715043re_verts
revests104413733re_vests
revets94022173re_ve_ts
rewears102911033re_wears
rewets94617213re_we_ts
rheas84816953r__hea_s
richens12349733riche_ns
riches115022083riche__s
richest122813683richest_
rickets134915093ricke_ts
rochet115423003roche_t_
rockets134615363rocke_ts
ruches114819583ruche__s
sachets123914103sache_ts
secrets9311773secre_ts
tracheas13410273trachea_s
tracheate1448233tracheate
tracheates1547923tracheates
wechts1446253wech__ts
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 Limit1461621776.98620922.1
3Display Results1771770.0602950.0
 (SQL Overall)1786911777.46623934.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.