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

114 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
poachiest163688(None) 
peachiest1638521peachiest
pouchiest1636841pouchiest
achiest12315182__achiest
beachiest1638442beachiest
botchiest1636152botchiest
leachiest1437242leachiest
paciest112917802p_ac_iest
patchiest1638352patchiest
pitchiest1646702pitchiest
plashiest1478372plashiest
poaches144416942poach_es_
poachier1556822poachie_r
pockiest163412052po_ckiest
preachiest1746982preachiest
punchiest1636452punchiest
torchiest1438032torchiest
touchiest1437082touchiest
ashiest10313953__ashiest
beechiest1645003beechiest
bitchiest1636083bitchiest
blotchiest1743523blotchiest
branchiest1746713branchiest
brashiest14359853brashiest
bunchiest1635663bunchiest
catchiest1638313catchiest
chichiest1936343chichiest
coaches144018693coach_es_
coaliest10316223coa_liest
cockiest163013293co_ckiest
conchies153214853conchies_
couthiest1439403couthiest
dashiest12311113_dashiest
doughiest1435783doughiest
flashiest1557983flashiest
foamiest13289853foa_miest
grouchiest1644123grouchiest
heathiest1549383heathiest
hoariest11312883hoa_riest
hoochies1639603hoochies_
itchiest1336523_itchiest
laciest93819033_lac_iest
lathiest11312653_lathiest
loaches123613983loach_es_
loamiest102310203loa_miest
mothiest13311033mo_thiest
mouthiest1438363mouthiest
oakiest112913923_oa_kiest
pachisi14329523p_achi_si
paliest93021603p_a_liest
palliest102814633p_alliest
palmiest123212023p_almiest
pappiest112611113p_appiest
pastiest103319543p_astiest
paunchiest1743853paunchiest
pawkiest17277883p_awkiest
peaches144120053peach_es_
peachier1548623peachie_r
peakiest143512993pea_kiest
pearliest1139353pearliest
peatiest103118803pea_tiest
peckiest162711393p_eckiest
pickiest162712593p_ickiest
pithiest132711443p_ithiest
platiest103216083pla_tiest
pluckiest1735293pluckiest
plushiest1466393plushiest
poached154212403poach_e_d
poacher143912323poach_e_r
poachers152910763poach_ers
poaching163510833poachi_ng
podgiest12269093po_dgiest
pointiest1139623pointiest
pokiest133314913po__kiest
pooches143214163pooch_es_
porches143815673porch_es_
porkiest143513713po_rkiest
porniest103214313po_rniest
portliest11310183portliest
poshest12312423po_sh_est
pottiest102815973po_ttiest
pouches144116743pouch_es_
pouchier1546803pouchie_r
poutiest103016793po_utiest
poxiest163412253po__xiest
priciest122112903pric_iest
prickiest1748183prickiest
pushiest133211713p_ushiest
quackiest2435183quackiest
raciest92820013_rac_iest
reechiest1446013reechiest
roaches123616213roach_es_
rockiest142912223ro_ckiest
slouchiest1543973slouchiest
snatchiest1545153snatchiest
soapiest102412843soa_piest
spaciest122310893spac_iest
splashiest1544463splashiest
splotchiest1852083splotchiest
starchiest1547183starchiest
tachist12613293_tachi_st
tackiest143112433_tackiest
techiest1359833_techiest
tetchiest1445793tetchiest
thatchiest1844163thatchiest
toastiest937423toastiest
toothiest1237523toothiest
trashiest123110633trashiest
wackiest172610273_wackiest
washiest14310403_washiest
whackiest2144983whackiest
witchiest1736313witchiest
worthiest1538323worthiest
wrathiest1536973wrathiest

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.1701051123.5
2DLD Change Limit1486411147.76619140.0
3Display Results1141140.0462478.3
 (SQL Overall)1786911147.98222386.7
 
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.