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

162 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
repatch143584(None) 
rematch1436191rematch
despatch1643222despatch
eparch13258422_eparch
patch125221222__patch
ratch104221362r__atch
reach105123882re_a_ch
repack142412162repa_ck
repatched1745312repatched
repatches1636712repatches
retch104818302re__tch
batch124620103__batch
beach124623893be_a_ch
bewitch1743323bewitch
breach134213723bre_a_ch
breath113916263bre_at_h
bycatch1942063bycatch
bypath1645353bypat_h
catch125120373__catch
cratch134110793_cratch
death94822523de_at_h
debauch15134423debauch
depth114311853dep_t_h
detach12310413deta_ch
dethatch1742753dethatch
dispatch1654553dispatch
each95530583_e_a_ch
eath75735663_e_at_h
epact94921533_epa_ct
epacts105010393_epacts
eparchs14196243_eparchs
eparchy17204753_eparchy
epoch1248203_ep_och
etch95419143_e__tch
exarch18196173_exarch
fetch134913473fe__tch
hatch135719593__hatch
heath115724283he_at_h
hepatic141712773hepatic
hepatica15177593hepatica
hepatics15198933hepatics
heptarch1843563heptarch
ketch144912023ke__tch
klatch15445933_klatch
kreplach1942613kreplach
kreplech1941583kreplech
latch104620463__latch
leach105422523le_a_ch
letch105215803le__tch
match125621103__match
mesarch1445533mesarch
mispatch1743853mispatch
natch105018223__natch
neath86020283ne_at_h
parch125123003__parch
patchy16509573__patchy
path99134913__pat_h
peach125422493pe_a_ch
pitch125018413__pitch
preach133613923pre_a_ch
prepack1757643prepa_ck
prepunch1743643prepunch
ranch105019793r__anch
rath76037663r__at_h
react74634333re_a_ct
reacts83616603re_acts
reata54225393re_at_a
reatas64021013re_atas
reattach1343743reattach
rebate84424113rebat_e
rebated103619703rebated
rebater93517913rebater
rebates95123183rebates
rebato83714683rebat_o
rebatos92913113rebatos
rebranch1545803rebranch
redact9419043reda_ct
redacts10510943redacts
redate74124683redat_e
redated93120923redated
redates83423873redates
reface113616353refa_ce
regatta835963regatta
rehash1237433reha_sh
relace83122153rela_ce
relate64033633relat_e
related83327573related
relater73723143relater
relates73731433relates
relator74016363relator
relaunch1352803relaunch
rematched1745223rematched
rematches1636653rematches
remate84428683remat_e
remated103522473remated
remates93827113remates
repacks15269543repacks
repaid94716323repa_id
repaint9318363repaint
repair84011463repa_ir
repairs9319973repairs
repand95316063repa_nd
repanel939963repanel
repaper11310023repaper
repark123511713repa_rk
reparks13249513reparks
repartee10312753repartee
repass84114703repa_ss
repast83520633repa_st
repasted112611533repasted
repasts93611933repasts
repatching1844993repatching
repave114813873repa_ve
repaved133311133repaved
repaves123513653repaves
repay104818453repa__y
repays113813973repa_ys
repeat85127213repeat__
repeated113117443repeated
repeater102615443repeater
repeats94316053repeat_s
replace113214283replace
replate93420053replat_e
replated112817513replated
replates102919273replates
replica1137943replica
repot75132623repot__
repots85621003repot_s
reprice113212833reprice
reproach1544953reproach
reptant92817073reptant
repute84716093reput_e
reputed104613483reputed
reputes94615963reputes
rerack122513163rera_ck
resat55139683resat__
research1344553research
resketch1742133resketch
respace11310913respa_ce
restack1339433restack
restitch1344693restitch
retack122612823reta_ck
reteach1237413reteach
retouch1235853retouch
revanche1645003revanche
rewash1237673rewa_sh
roach105717003r_oa_ch
rotch105815933r__otch
scratch1446013scratch
search113312423se_arch
seecatch1542693seecatch
slatch114510533_slatch
snatch114310603_snatch
swatch14549283_swatch
teach105221123te_a_ch
thatch1435613_thatch
unlatch1245053unlatch
vetch134411843ve__tch
watch135617063__watch
wreath124111193wre_at_h
wretch14326533wre__tch
xerarch1943843xerarch

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.1561145455.1
2DLD Change Limit1340271627.29618369.9
3Display Results1621620.0632571.4
 (SQL Overall)1786911627.51523777.9
 
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.