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

116 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
ranch10501979(None) 
branch134014781branch
cranch133613531cranch
rance75028511rance
rancho114310851rancho
ratch104221361ratch
raunch11358431raunch
ancho104515302_ancho
ankh111114412_ankh
arch98628442_arch
bach116131392ba_ch
banco94019392banco
batch124620102batch
bench125619502bench
blanch133410852blanch
brach126123302bra_ch
branchy17357912branchy
brunch13329352brunch
bunch125118602bunch
cancha134411612cancha
catch125120372catch
cinch124516242cinch
conch124620072conch
cratch134110792cratch
craunch1464442craunch
crunch13349502crunch
dance85223132dance
drench12369592drench
dunch115316262dunch
each95530582ea_ch
fancy134615482fancy
finch135416972finch
franc104615412franc_
francs114112192francs
french143511212french
grinch1238482grinch
hance105424152hance
hatch135719592hatch
haunch14377342haunch
hunch136416212hunch
inch95420822_inch
kench145513922kench
laich105920712laich
lance75126722lance
larch105919792larch
latch104620462latch
launch11368062launch
lunch104917242lunch
lynch13468982lynch
mach116134482ma_ch
manche133515102manche
march125622892march
match125621102match
munch124917102munch
nance74721842nance
nancy105214922nancy
natch105018222natch
orach105219232ora_ch
painch133511322painch
parch125123002parch
patch125221222patch
paunch13369852paunch
pinch125619302pinch
planch133711442planch
prance104318572prance
punch125118422punch
race66746262ra_ce
rack106234882ra_ck
racy95825682ra_cy
rah68052402ra__h
rajah155711422rajah
ralph1078742ralph
ran38266622ran__
rances84625442rances
ranched133113602ranched
rancher123013632rancher
ranches123620112ranches
ranchos123911392ranchos
rancid9513862rancid
rancor8810372rancor
rand55839572ran_d
rands65930452rands
randy95022082randy
ranee55438102ranee
rang56939172ran_g
range64728422range
rangy95320392rangy
rani46640112ran_i
ranid66429332ranid
ranis55235842ranis
rank85135532ran_k
ranks95225732ranks
rant45864682ran_t
rants55935342rants
rash76039932ra_sh
rath76037662ra_th
raunchy15284312raunchy
rayah116013502rayah
reach105123882reach
retch104818302retch
rich97025552r_ich
roach105717002roach
rotch105815932rotch
sangh95517462sangh
sauch104918772sauch
stanch113812372stanch
synch135011792synch
tach96132752ta_ch
tench105620002tench
trance84718762trance
tranche123312222tranche
trench114211612trench
watch135617062watch
wench136214782wench
winch135016662winch
wrench14439352wrench

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.313570897.8
2DLD Change Limit538001161.71631352.0
3Display Results1161160.0333515.2
 (SQL Overall)1786911162.06286659.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.