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

172 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
poachier155682(None) 
peachier1548621peachier
poacher143912321poach_er
pouchier1546801pouchier
achier113914262__achier
beachier1538802beachier
botchier15287142botchier
coacher143714122coach_er
leachier1337252leachier
pacier105018682p_ac_ier
patchier15319672patchier
peacher144216072peach_er
pitchier15368272pitchier
plashier1337612plashier
poached154212402poach_ed
poachers152910762poach_ers
poaches144416942poach_es
poachiest1636892poachiest
poaching163510832poaching
pockier153911602po_ckier
preachier1646922preachier
punchier1536412punchier
torchier1337462torchier
touchier1347382touchier
ashier94714833__ashier
beechier1535633beechier
bitchier15307733bitchier
blotchier1643213blotchier
botcher143613223botch_er
branchier1637133branchier
brashier13389933brashier
broacher15329263broach_er
bunchier1536153bunchier
cahier113615773_ca_hier
cashier123713323_cashier
catchier15329863catchier
chichier1836023chichier
coached153313843coach_ed
coachers154312303coach_ers
coaches144018693coach_es
coaching164011963coaching
coachmen1745013coachmen
coalier93416183coa_lier
cockier154013623co_ckier
conchie143312683conchie_
conchies153214853conchies
coucher144515853couch_er
couthier13218913couthier
dashier114311183_dashier
doughier1335483doughier
flashier1437103flashier
foamier12339003foa_mier
glacier103911303glac_ier
grouchier1543843grouchier
heathier1438343heathier
hoarier104211743hoa_rier
hoochie1537803hoochie_
hoochies1639603hoochies
itchier12247673_itchier
lacier84020093_lac_ier
lathier10310833_lathier
leacher124014843leach_er
loaches123613983loach_es
loamier9349163loa_mier
loather103711003loath_er
moocher143610673mooch_er
mothier121910213mo_thier
mouthier13208173mouthier
notcher123610933notch_er
oakier104011393_oa_kier
ocher104516103_o_ch_er
opacifier1643623opacifier
pacer96131613p_ac__er
pachisi14329523p_achisi
pacifier1557503p_acifier
packer144223403p_ac_ker
palier85023573p_a_lier
pallier94417173p_allier
palmier113312183p_almier
panier84425503p_a_nier
pannier93613353p_annier
pappier103511603p_appier
parrier93717653p_arrier
partier93520713p_artier
pastier94320383p_astier
patcher143515143patch_er
paunchier1643333paunchier
pawkier16236613p_awkier
peached154315883peach_ed
peachers153213843peach_ers
peaches144120053peach_es
peachiest1638533peachiest
peaching163613643peaching
peakier134411443pea_kier
pearlier1037323pearlier
peatier94017233pea_tier
peckier153910523p_eckier
percher143313423perch_er
pickier153912973p_ickier
pincher143812713pinch_er
pitcher143813713pitch_er
pithier123010293p_ithier
placater1238013placater
placer105117743plac__er
plasher124215033plash_er
platier93716293pla_tier
pluckier16295073pluckier
plushier1375193plushier
poach124917863poach___
poachy16388963poach__y
podgier11338723po_dgier
poechore1547853poechore
pointier1038303pointier
pokier124914633po__kier
ponchoed1646133ponchoed
pooched152810083pooch_ed
pooches143214163pooch_es
pooching16328983pooching
porches143815673porch_es
porkier133712343po_rkier
pornier93413133po_rnier
portlier1038373portlier
posher115018163po_sh_er
pother113818853po_th_er
pottier93516493po_ttier
pouched153612773pouch_ed
pouches144116743pouch_es
pouchiest1636843pouchiest
pouching163210413pouching
poutier93215323po_utier
poxier153812113po__xier
practicer1544593practicer
preacher153211373preach_er
pricier113313113pric_ier
prickier16368143prickier
puncher143311673punch_er
pushier123611093p_ushier
quackier23215373quackier
racier85120973_rac_ier
reacher123718293reach_er
reechier1336673reechier
roached133211833roach_ed
roaches123616213roach_es
roaching143210433roaching
rockier134911883ro_ckier
slouchier1443603slouchier
snatchier1455353snatchier
soapier93411713soa_pier
spacier114011633spac_ier
splashier1443593splashier
splotchier1741933splotchier
starchier1436643starchier
tackier133712523_tackier
teacher123714833teach_er
techier1269243_techier
tetchier1336453tetchier
thatchier1743983thatchier
toastier846893toastier
tocher114014913to_ch_er
toothier1136423toothier
torchiere1443573torchiere
torchiers1445073torchiers
toucher124814353touch_er
trashier113210103trashier
voucher154110263vouch_er
wackier16369733_wackier
washier133611153_washier
whackier2044673whackier
witchier16307883witchier
worthier1436713worthier
wrathier1435903wrathier
yachter1534913_yachter

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.436409841.7
2DLD Change Limit1461621727.08020644.4
3Display Results1721720.0602866.7
 (SQL Overall)1786911727.57623586.5
 
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.