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 “retch” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

114 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
retch10481830(None) 
etch95419141_etch
fetch134913471fetch
ketch144912021ketch
letch105215801letch
ratch104221361ratch
reach105123881reach
rotch105815931rotch
vetch134411841vetch
wretch14326531wretch
aitch105216162aitch
batch124620102batch
beach124623892beach
beech124315502beech
belch124415502belch
bench125619502bench
beth96629232bet_h
bitch125017762bitch
botch126717452botch
breach134213722breach
breech13348262breech
butch125416542butch
catch125120372catch
cratch134110792cratch
crotch133410082crotch
crutch13408242crutch
cutch125116192cutch
detach12310412detach
ditch115015092ditch
dreich12377722dreich
drench12369592drench
dutch114713822dutch
each95530582_each
eth66630982_et_h
fetich1479692fetich
fitch134816872fitch
fletch14388192fletch
french143511212french
grutch12285562grutch
hatch135719592hatch
heth107028022het_h
heuch135312332heuch
hitch134515472hitch
hotch136214732hotch
hutch135414092hutch
itch95619172_itch
kench145513922kench
kvetch1832992kvetch
latch104620462latch
leach105422522leach
lech96825442le_ch
leech104913212leech
match125621102match
merch125417962merch
meth95827842met_h
mutch125016172mutch
natch105018222natch
notch105613322notch
patch125221222patch
peach125422492peach
pech116125452pe_ch
perch124518832perch
pitch125018412pitch
preach133613922preach
ranch105019792ranch
rath76037662rat_h
react74634332react
rec55645462re_c_
recce9514562recce
reck106130562re_ck
recs65734182re_cs
recta74220262recta
recti73619622recti
recto74520802recto
reecho11318652reecho
reechy14367822reechy
rematch1436192rematch
repatch1435842repatch
resh76523452re_sh
ret35982832ret__
retack122612822retack
retag63618412retag
retax124517972retax
retched133814272retched
retches123318512retches
rete44944132ret_e
reteach1237412reteach
retem74221952retem
retia55326112retia
retie55735302retie
retouch1235852retouch
retro55020952retro
retry84718082retry
rets45352562ret_s
rich97025542r_ich
roach105717002roach
rotche114311982rotche
ruth76825992rut_h
sketch1535362sketch
stretch1236412stretch
teach105221122teach
tech95925442te_ch
tench105620002tench
tetchy1436002tetchy
teth76327892tet_h
teuch105214852teuch
trench114211612trench
watch135617062watch
welch134411492welch
wench136214782wench
witch134517562witch
wrench14439352wrench
yecch15558092yecch
yech127220532ye_ch

Search took 2 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 Filter178691538000.0961861364.6
2DLD Change Limit538001141.81029723.8
3Display Results1141140.0333454.5
 (SQL Overall)1786911141.93992156.3
 
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.