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

205 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
patchier1531966(None) 
catchier15329861catchier
patcher143515141patch_er
pitchier15368271pitchier
achier113914262_a_chier
batcher144414852batch_er
bitchier15307732bitchier
botchier15287142botchier
catcher143115822catch_er
hatcher153314722hatch_er
itchier12247672_itchier
lathier10310832lat_hier
matcher143214282match_er
pacier105018682pa_c_ier
patched153514622patch_ed
patchers153413302patch_ers
patches143320382patch_es
patchiest1638352patchiest
patchily1885812patchily
patching163212752patching
paunchier1643332paunchier
peachier1548622peachier
pitcher143813712pitch_er
pithier123010292pit_hier
poachier1556822poachier
pouchier1546802pouchier
punchier1536412punchier
snatchier1455352snatchier
tetchier1336452tetchier
thatchier1743982thatchier
watcher153113402watch_er
witchier16307882witchier
apathies1339003apat_hies
archer115016243_arch_er
ashier94714833_a_shier
atelier7311623_atelier
batched154114243batch_ed
batchers153613273batch_ers
batches144019613batch_es
batching163712093batching
bather115322513bat_h_er
battier93515713bat_tier
beachier1538803beachier
beechier1535633beechier
blotchier1643213blotchier
botcher143613223botch_er
branchier1637133branchier
bunchier1536153bunchier
butcher143411163butch_er
cahier113615773ca__hier
cashier123713323ca_shier
catbrier1236173catbrier
catchers153114063catch_ers
catches144320773catch_es
catchiest1638313catchiest
catching163712773catching
catechizer2643143catechizer
cattier93317073cat_tier
chichier1836023chichier
dashier114311183da_shier
ditcher134012003ditch_er
earthier1137443earthier
eparchies1646973eparchies
etcher113912943_etch_er
fancier123412063fanc_ier
father125116713fat_h_er
fattier103513463fat_tier
fetcher153510393fetch_er
gather104115853gat_h_er
gaucher1337233gauch_er
glitchier1542793glitchier
hatched163414463hatch_ed
hatchel153510753hatch_el
hatchers163113173hatch_ers
hatchery19326383hatch_ery
hatches153420273hatch_es
hatchet153317563hatch_et
hatching173312213hatching
heathier1438343heat_hier
hitcher153712003hitch_er
katchina1745333katchina
kvetchier2141863kvetchier
lacier84020093la_c_ier
latched133914063latch_ed
latches123320123latch_es
latchet123117903latch_et
latching143712023latching
latchkey2042913latchkey
lather95124353lat_h_er
leachier1337253leachier
luthier1038233lut_hier
macchie1647193macchie_
marcher143912973march_er
marshier1337593marshier
matched153513963match_ed
matchers153012433match_ers
matches143219783match_es
matching163512393matching
matier84321523mat__ier
mothier121910213mot_hier
mythier15125183myt_hier
nattier73614623nat_tier
nitchie1247233nitchie_
nitchies1339073nitchies
notcher123610933notch_er
pacer96131613pa_c__er
pachisi14329523pa_chisi
pacifier1557503pacifier
packer144223403pa_c_ker
paintier1048793paintier
palier85023563pa__lier
pallier94417163pa_llier
palmier113312173pa_lmier
paltrier1037523paltrier
panickier1743173panickier
panier84425503pa__nier
pannier93613353pa_nnier
panther12611443panth_er
pappier103511593pa_ppier
parcener1238473parcener
parched154013693parch_ed
parches143720003parch_es
parching164313053parching
parchisi15368933parchisi
parrier93717653pa_rrier
partier93520713pa_rtier
pastier94320383pa_stier
patch125221223patch___
patchiness1744933patchiness
patchwork2343893patchwork
patchy16509573patch__y
pater74740723pat___er
patissier1143183patissier
patsies93919483pat_sies
patter84628263pat__ter
patterer103112173patterer
pattie84020963pat_tie_
patties93425143pat_ties
patzer173111643pat__zer
pawkier16236613pa_wkier
peacher144216073peach_er
peatier94017233peat__ier
peckier153910523p_eckier
percher143313423perch_er
pettier94213613pet_tier
pickier153912973p_ickier
pincher143812713pinch_er
pitched153512923pitch_ed
pitchers153211483pitch_ers
pitches143617753pitch_es
pitchiest1646703pitchiest
pitchily1855013pitchily
pitching163411113pitching
pitchmen1744333pitchmen
pitier84019823pit__ier
plashier1337613plashier
platier93716293plat__ier
pluckier16295073pluckier
plushier1375193plushier
poacher143912323poach_er
pockier153911603p_ockier
pother113818853pot_h_er
pottier93516493pot_tier
preachier1646923preachier
pricier113313113pric_ier
prickier16368143prickier
puncher143311673punch_er
pushier123611093p_ushier
puttier93314503put_tier
racier85120973ra_c_ier
rancher123013633ranch_er
ratches123620463ratch_es
ratchet124218333ratch_et
rather94319743rat_h_er
ratifier1139673ratifier
rattier74015593rat_tier
raunchier1443713raunchier
reechier1336673reechier
satchel123310303satch_el
saucier9810283sauc_ier
scratchier1744343scratchier
sketchier1853413sketchier
smutchier1643503smutchier
snatcher13167763snatch_er
spacier114011633spa_c_ier
splotchier1741933splotchier
starchier1436643starchier
tackier133712523ta_ckier
tattier74216243tat_tier
techier1269243_techier
thatcher1635663thatch_er
torchier1337463torchier
touchier1347383touchier
twitchier1753233twitchier
wackier16369733wa_ckier
washier133611153wa_shier
watched163012823watch_ed
watchers163511793watch_ers
watches153017373watch_es
watching173011173watching
watchmen1844753watchmen
waterier11312083waterier
withier132910493wit_hier
wrathier1435903wrat_hier
yachter1534913ya_chter

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 Filter1786911461620.403443402.0
2DLD Change Limit1461622056.94021060.8
3Display Results2052050.0762697.4
 (SQL Overall)1786912057.41924085.6
 
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.