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

133 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
leachiest143724(None) 
beachiest1638441beachiest
peachiest1638521peachiest
achiest12315182__achiest
beechiest1645002beechiest
heathiest1549382heathiest
laciest93819032l_ac_iest
lathiest11312652l_athiest
leaches123319342leach_es_
leachier1337252leachie_r
leadiest93314982lea_diest
leafiest113410882lea_fiest
leakiest123212792lea_kiest
leariest83117842lea_riest
leaviest112910812lea_viest
poachiest1636882poachiest
preachiest1746982preachiest
reechiest1446012reechiest
techiest1359832te_chiest
tetchiest1445792tetchiest
ashiest10313953__ashiest
beaches144120653beach_es_
beachier1538803beachie_r
beadiest113815533bea_diest
beakiest143313463bea_kiest
beamiest123212763bea_miest
bitchiest1636083bitchiest
bleaches153410673bleach_es_
bleariest1158843blea_riest
blotchiest1743523blotchiest
botchiest1636153botchiest
branchiest1746713branchiest
brashiest14359853brashiest
breathiest1545993breathiest
bunchiest1635663bunchiest
catchiest1638313catchiest
chichiest1936343chichiest
cleanliest1244353cleanliest
dashiest12311113_dashiest
deadliest1138183deadliest
earliest82415243_earliest
earthiest1259103_earthiest
easiest72318773_ea_siest
featliest1238363featliest
flashiest1557983flashiest
fleeciest1434873fleec_iest
fleshiest1576223fle_shiest
gleamiest1235303glea_miest
glitchiest1642793glitchiest
headachiest2052423headachiest
headiest123015553hea_diest
healthiest1645273healthiest
heartiest12311103heartiest
heaviest143210443hea_viest
itchiest1336523_itchiest
kvetchiest2241953kvetchiest
laches116528343l_ach_es_
lakiest113517263l_a_kiest
lambiest122410183l_ambiest
lankiest122912493l_ankiest
lardiest93813883l_ardiest
larkiest123713313l_arkiest
laziest163814473l_a_ziest
leachates1446663leachates_
leached133715043leach_e_d
leacher124014843leach_e_r
leachers133712813leach_ers
leaching143012833leachi_ng
lealties8310793lealties_
leanest7415863lea__nest
leashes103514403leash_es_
leches115421313le_ch_es_
lechwes1535063le_chwes_
ledgiest10288593le_dgiest
leeches123911933leech_es_
leeriest83112883le_eriest
legacies1139043legac_ies_
leggiest10308233le_ggiest
lengthiest1442903lengthiest
letches124015483letch_es_
loaches123613983loach_es_
loamiest102310203loa_miest
luckiest143011443l_uckiest
mealiest102215973mea_liest
measliest1147173measliest
meatiest102816793mea_tiest
meshiest132911033me_shiest
nearliest949363nearliest
paciest112917803_pac_iest
patchiest1638353patchiest
peaches144120053peach_es_
peachier1548623peachie_r
peakiest143512993pea_kiest
pearliest1139353pearliest
peatiest103118803pea_tiest
peckiest162711393pe_ckiest
pitchiest1646703pitchiest
plashiest1478373plashiest
pleaches153210433pleach_es_
pouchiest1636843pouchiest
punchiest1636453punchiest
quackiest2435183quackiest
raciest92820013_rac_iest
reaches123423203reach_es_
readiest93719043rea_diest
seamiest102715413sea_miest
sketchiest1943163sketchiest
sleaziest1836053slea_ziest
slouchiest1543973slouchiest
snatchiest1545153snatchiest
spaciest122310893spac_iest
starchiest1547183starchiest
stenchiest1545083stenchiest
tachist12613293_tachi_st
tackiest143112433_tackiest
teaches122718353teach_es_
teariest82417263tea_riest
techies12513603te_chies_
thatchiest1844163thatchiest
torchiest1438033torchiest
touchiest1437083touchiest
trashiest123110633trashiest
treacliest1245383treacliest
vealiest112513203vea_liest
wackiest172610273_wackiest
washiest14310403_washiest
weakliest1635853weakliest
wealthiest1644113wealthiest
weariest112914793wea_riest
whackiest2144983whackiest
witchiest1736313witchiest
wrathiest1536973wrathiest
yeastiest1237203yeastiest

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 Limit1486411337.48619855.9
3Display Results1331330.0462891.3
 (SQL Overall)1786911337.70223200.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.