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

119 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
reach10512388(None) 
beach124623891beach
breach134213721breach
each95530581_each
leach105422521leach
peach125422491peach
preach133613921preach
react74634331react
retch104818301retch
roach105717001roach
teach105221121teach
bach116131392_bach
beachy164011252beachy
beech124315502beech
belch124415502belch
bench125619502bench
bleach133611402bleach
brach126123302brach
breath113916262breath
breech13348262breech
broach133611112broach
clach124617822clach
coach125919452coach
deash95617242deash
death94822522death
detach12310412detach
dreich12377722dreich
drench12369592drench
eath75735662_eath
etch95419142_etch
fetch134913472fetch
french143511212french
heath115724282heath
heuch135312332heuch
kench145513922kench
ketch144912022ketch
leachy14419732leachy
leash85519212leash
lech96825442le_ch
leech104913212leech
letch105215802letch
loach105116362loach
mach116134482_mach
merch125417962merch
neath86020282neath
orach105219232orach
peace95026082peace
peachy164510842peachy
pech116125452pe_ch
perch124518832perch
pleach134211242pleach
poach124917862poach
preachy17307312preachy
preact103220392preact
race66746262r_ace
rack106234882r_ack
racy95825682r_acy
rah68052402r_a_h
ranch105019792ranch
rash76039932r_ash
ratch104221362ratch
rath76037662r_ath
reached134619082reached
reacher123718292reacher
reaches123423202reaches
reacts83616602reacts
read55942532rea_d
readd74617132readd
reads64835272reads
ready94821502ready
real45750292rea_l
realm75621622realm
reals55038652reals
ream65841612rea_m
reams75729622reams
reap65934742rea_p
reaps75626192reaps
rear45644552rea_r
rearm75923572rearm
rears54739652rears
reata54225392reata
reave84528022reave
rec55645462re_c_
recap95718022recap
recce9514562recce
reck106130562re_ck
recs65734182re_cs
redact9419042redact
reecho11318652reecho
reechy14367822reechy
reface113616352reface
rehash1237432rehash
relace83122152relace
rematch1436192rematch
repack142412162repack
repatch1435842repatch
rerack122513162rerack
resh76523452re_sh
retack122612822retack
reteach1237412reteach
rewash1237672rewash
rich97025542r_ich
rotch105815932rotch
search113312422search
tach96132752_tach
tech95925442te_ch
tench105620002tench
teuch105214852teuch
trench114211612trench
upreach1444692upreach
vetch134411842vetch
welch134411492welch
wench136214782wench
wreath124111192wreath
wrench14439352wrench
wretch14326532wretch
yeah106725412yea_h
yecch15558092yecch
yech127220532ye_ch

Search took 3 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.296603685.8
2DLD Change Limit538001191.72031279.1
3Display Results1191190.0303966.7
 (SQL Overall)1786911192.04687336.8
 
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.