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

134 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
patchiest163835(None) 
catchiest1638311catchiest
pitchiest1646701pitchiest
achiest12315182_a_chiest
bitchiest1636082bitchiest
botchiest1636152botchiest
itchiest1336522_itchiest
lathiest11312652lat_hiest
paciest112917802pa_c_iest
patches143320382patch_es_
patchier15319662patchie_r
patchiness1744932patchiness
paunchiest1743852paunchiest
peachiest1638522peachiest
pithiest132711442pit_hiest
poachiest1636882poachiest
pouchiest1636842pouchiest
punchiest1636452punchiest
snatchiest1545152snatchiest
tetchiest1445792tetchiest
thatchiest1844162thatchiest
witchiest1736312witchiest
apathies1339003apat_hies_
ashiest10313953_a_shiest
atheist10314063_at_heist
athirst1037873_at_hirst
batches144019613batch_es_
battiest104115553bat_tiest
beachiest1638443beachiest
beechiest1645003beechiest
blotchiest1743523blotchiest
branchiest1746713branchiest
bunchiest1635663bunchiest
catches144320773catch_es_
catchier15329863catchie_r
catchment1846293catchment
catechist1656803catechi_st
cattiest103016333cat_tiest
chichiest1936343chichiest
dashiest12311113da_shiest
earthiest1259103earthiest
eparchies1646973eparchies_
fanciest133612713fanc_iest
fattiest113514313fat_tiest
gauchest1436293gauch_est
glitchiest1642793glitchiest
hatches153420273hatch_es_
hatchet153317563hatch_e_t
hatchets163310383hatch_ets
hatchment1945313hatchment
heathiest1549383heat_hiest
kvetchiest2241953kvetchiest
laciest93819033la_c_iest
latches123320123latch_es_
latchet123117903latch_e_t
latchets133410013latch_ets
leachiest1437243leachiest
marshiest1438103marshiest
matches143219783match_es_
matchless1644683matchless
matiest92522453mat__iest
mothiest13311033mot_hiest
mythiest1636033myt_hiest
nattiest83215353nat_tiest
nitchies1339073nitchies_
pachisi14329523pa_chi_si
paintiest11310563paintiest
paliest93021603pa__liest
palliest102814633pa_lliest
palmiest123212023pa_lmiest
paltriest1138603paltriest
panickiest1843493panickiest
pantheist1449153pantheist
pappiest112611113pa_ppiest
parcheesi16233763parcheesi
parches143720003parch_es_
parchesi15358213parch_esi
parchisi15368933parchi_si
parchment1846913parchment
pastiest103319543pa_stiest
patched153514623patch_e_d
patcher143515143patch_e_r
patchers153413303patch_ers
patchily1885813patchi_ly
patching163212753patchi_ng
pathless13138043pat_hless
patient9617073pat__ient
patsies93919483pat_sies_
patties93425143pat_ties_
pawkiest17277883pa_wkiest
peatiest103118803peat__iest
peckiest162711393p_eckiest
pettiest103113963pet_tiest
pickiest162712593p_ickiest
pitches143617753pitch_es_
pitchier15368273pitchie_r
plashiest1478373plashiest
platiest103216083plat__iest
pluckiest1735293pluckiest
plushiest1466393plushiest
pockiest163412053p_ockiest
pottiest102815973pot_tiest
preachiest1746983preachiest
priciest122112903pric_iest
prickiest1748183prickiest
pushiest133211713p_ushiest
putschist1644183putschi_st
raciest92820013ra_c_iest
ratches123620463ratch_es_
ratchet124218333ratch_e_t
ratchets133110263ratch_ets
rattiest83516113rat_tiest
raunchiest1543933raunchiest
reechiest1446013reechiest
sauciest10310973sauc_iest
scratchiest1844143scratchiest
sketchiest1943163sketchiest
smutchiest1743263smutchiest
spaciest122310893spa_c_iest
splotchiest1852083splotchiest
starchiest1547183starchiest
tachist12613293ta_chi_st
tackiest143112433ta_ckiest
tattiest83415383tat_tiest
techiest1359833_techiest
torchiest1438033torchiest
touchiest1437083touchiest
twitchiest1842963twitchiest
wackiest172610273wa_ckiest
washiest14310403wa_shiest
watches153017373watch_es_
wateriest12312233wateriest
withiest142411243wit_hiest
wrathiest1536973wrat_hiest

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 Filter1786911486410.1561145455.1
2DLD Change Limit1486411346.95321378.0
3Display Results1341340.0632127.0
 (SQL Overall)1786911347.17224915.1
 
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.