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

230 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
techiest135983(None) 
techies12513601techies_
tetchiest1445791tetchiest
achiest12315192_achiest
beachiest1638452beachiest
beechiest1645002beechiest
itchiest1336522itchiest
leachiest1437252leachiest
meshiest132911032meshiest
peachiest1638532peachiest
peckiest162711392peckiest
reechiest1446012reechiest
stenchiest1545082stenchiest
tachist12613292tachi_st
tackiest143112432tackiest
teariest82417262teariest
techie11511722techie__
techier1269242techie_r
teeniest82112412teeniest
tentiest82115612tentiest
testiest82715222testiest
torchiest1438032torchiest
touchiest1437082touchiest
aeriest73924053ae_riest
ashiest10313963_ashiest
beadiest113815533beadiest
beakiest143313463beakiest
beamiest123212763beamiest
beefiest13269013beefiest
beeriest104013403beeriest
behest11314613be_h_est
bendiest112311983bendiest
bitchiest1636083bitchiest
botchiest1636153botchiest
bunchiest1635663bunchiest
bushiest133512523bushiest
catchiest1638313catchiest
catechist1656803catechi_st
chest104926143__ch_est
chicest14209943__chicest
chichiest1936343chichiest
cockiest163013293cockiest
cushiest133411043cushiest
dashiest12311123dashiest
decries103319803decries_
deediest102912253deediest
dewiest11312343de_wiest
diciest103316523dic_iest
dickiest153412503dickiest
dictiest113212783dictiest
dishiest12313683dishiest
duchies133312313duchies_
duckiest153211863duckiest
easiest72318773_easiest
eches106322163_ech_es_
echoes114715523_echoes_
edgiest92310353_edgiest
eeliest73516473_eeliest
eeriest73620673_eeriest
elmiest9310743_elmiest
etches114217763etch_es_
fenniest113113203fenniest
ferniest1132214153ferniest
fishiest14310453fishiest
fleshiest1576233fleshiest
geekiest13257873geekiest
gemmiest13227633gemmiest
germiest11249923germiest
gushiest123510983gushiest
headiest123015553headiest
heathiest1549393heathiest
heaviest143210443heaviest
hedgiest13298133hedgiest
heftiest1439183heftiest
hempiest1539043hempiest
herbiest1339993herbiest
iciest82914743_ic_iest
ickiest133611043_ickiest
jerkiest19328113jerkiest
jettiest15359593jettiest
kickiest13319673kickiest
kvetchiest2241953kvetchiest
laciest93819043lac_iest
lathiest11312663lathiest
leadiest93314993leadiest
leafiest113410893leafiest
leakiest123212803leakiest
leariest83117853leariest
leaviest112910823leaviest
leches115421313lech_es_
lechwes1535063lechwes_
ledgiest10288593ledgiest
leeriest83112883leeriest
leggiest10308233leggiest
luckiest143011443luckiest
mealiest102215973mealiest
meatiest102816793meatiest
merriest10311483merriest
messiest103112423messiest
mothiest13311033mothiest
muckiest163210913muckiest
mushiest133212873mushiest
mythiest1636043mythiest
neediest92611303neediest
nerdiest92511163nerdiest
nerviest11188833nerviest
nettiest83112433nettiest
newsiest11107483newsiest
paciest112917813pac_iest
patchiest1638353patchiest
peakiest143513003peakiest
peatiest103118813peatiest
peppiest11278573peppiest
perkiest143313243perkiest
peskiest142610163peskiest
pestiest103018413pestiest
pettiest103113963pettiest
pickiest162712593pickiest
pitchiest1646703pitchiest
pithiest132711443pithiest
poachiest1636893poachiest
pockiest163412053pockiest
pouchiest1636843pouchiest
preachiest1746983preachiest
punchiest1636453punchiest
pushiest133211713pushiest
raciest92820013rac_iest
readiest93719043readiest
recheat12415933rech_eat
reediest92815423reediest
reefiest112811483reefiest
reekiest122711313reekiest
richest122813683rich_est
rockiest142912223rockiest
rushiest113312923rushiest
schist11312653_schi_st
seamiest102715423seamiest
securest1058583securest
sedgiest10259763sedgiest
seediest92714053seediest
seepiest102412633seepiest
sexiest142112223se_xiest
shiest95821533__shiest
sketchiest1943163sketchiest
starchiest1547193starchiest
steadiest1038523steadiest
steamiest1138413steamiest
steeliest939643steeliest
stemmiest1335143stemmiest
stickiest15229603stickiest
stockiest15207753stockiest
stretchiest1644193stretchiest
suckiest143314113suckiest
taches114224173tach_es_
tachism1478873tachi_sm
tachiste1356213tachi_ste
tachists1348183tachi_sts
talkiest123611223talkiest
tangiest92915223tangiest
tardiest93515243tardiest
tarriest83215003tarriest
tartiest82718313tartiest
tastiest83216633tastiest
tattiest83415383tattiest
tawniest11279343tawniest
teaches122718353teach_es_
teched124014433tech_e_d
techily1537123techi_ly
technics1585463technics_
technos1236183technos_
techs106915833tech__s_
tectites1039993tectites_
teddies92711283teddies_
teensiest945833teensiest
tekkies1035943tekkies_
tellies73820503tellies_
tempest1139223te_mpest
tenches123515523tench_es_
tennies73017973tennies_
tennist72813113tenni_st
tensest72713313te_nsest
terries73425633terries_
tersest71713993te_rsest
tetchier1336453tetchie_r
tetchiness1543583tetchiness
thatchiest1844163thatchiest
theist9314763t__heist
thewiest14196343thewiest
thirst9312253t__hirst
thymiest1634733thymiest
tidiest83514873t_idiest
tightest12148363tightest
tiniest73020123t_iniest
tinniest82911463tinniest
tippiest122310023tippiest
tipsiest10228953tipsiest
toniest73218903t_oniest
toothiest1237523toothiest
trashiest123110643trashiest
treacliest1245383treacliest
trendiest1038423trendiest
tressiest937883tressiest
trickiest1549023trickiest
tubbiest12117293tubbiest
tuftiest1138283tuftiest
turfiest112410133turfiest
tushies10312163tushies_
tweakiest1634053tweakiest
tweediest1344273tweediest
twiniest1147153twiniest
twitchiest1842963twitchiest
typiest1238203t_ypiest
vealiest112513203vealiest
veiniest1139383veiniest
veriest103719133ve_riest
vichies15310623vichies_
wackiest172610273wackiest
washiest14310413washiest
weariest112914793weariest
webbiest1535353webbiest
wedgiest13307983wedgiest
weediest122311133weediest
weeniest112411213weeniest
weepiest13219473weepiest
wenniest11259593wenniest
witchiest1736313witchiest
withiest142411243withiest
yuckiest17328833yuckiest
zechins21137123zechins_
zestiest173011103zestiest

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.420425454.8
2DLD Change Limit1461622306.65621959.4
3Display Results2302300.0932473.1
 (SQL Overall)1786912307.16924925.5
 
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.