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

257 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
potherb1435868(None) 
pother113818851pother_
potherbs15387121potherbs
pothers123818621pothers
bother115218062bother_
bothers124317752bothers
cowherb1735102cowherb
mother113718642mother_
mothers123717622mothers
mothery153710512mothery
nother93815962nother_
other84219102_other_
others93918002_others
posher115018162posher_
pothead133810392pothead
potheen12257892potheen
pothered142311042pothered
potsherd1434812potsherd
potter83926982potter_
potters94024342potters
pottery123011072pottery
potzer174411212potzer_
potzers184010542potzers
tother94117142tother_
aether94213673aether_
aethers103614943aethers
another10289153another_
anther93715063anther_
anthers103715203anthers
apothece1543773apothece
apothegm1652123apothegm
apothem1444643apothe_m
apothems1544223apothems
bather115322513bather_
bathers124720363bathers
botcher143613223botcher_
botchers153511543botchers
botchery18366763botchery
bothered142110393bothered
brother123311333brother_
brothers133410833brothers
cither114616683cither_
cithern12489913cithern
cithers124315773cithers
cohere112716993co_here
cosher114819903cosher_
coshers123618183coshers
cothurn1245053cothurn
cotter84926673cotter_
cotters94323443cotters
couther123914633couther_
cowherbs1833543cowherbs
cowherd1636953cowherd
dither104417683dither_
dithers114016153dithers
dithery14318943dithery
doter65428623dot_er_
doters74423913dot_ers
dotier73917033dotier_
dotter74419343dotter_
dotters83715973dotters
either94517423either_
ether84518773_ether_
ethers94518413_ethers
father125116713father_
fathers133916503fathers
frother133110153frother_
frothers14279813frothers
gather104115853gather_
gathers114315073gathers
goatherd1335263goatherd
gopher1239183gopher_
gophers1338983gophers
herb94730963___herb
hither124417253hither_
hothead14349293hothead
hotter94720083hotter_
isothere1145793isothere
isotherm1344283isotherm
ither84617603_ither_
josher164312963josher_
joshers174111593joshers
jotter134315633jotter_
jotters143413803jotters
kosher134412973kosher_
koshers144811803koshers
lather95124353lather_
lathers104321883lathers
lathery133911123lathery
lither94520953lither_
loather103711003loather_
loathers113310443loathers
lotter64025603lotter_
lotters73921063lotters
lottery10389833lottery
luthern1037653luthern
mither114218563mither_
mithers123516733mithers
mosher114719793mosher_
moshers124017843moshers
mothered142310103mothered
motherly16346093motherly
mothier121910213mothier_
mouther123812813mouther_
mouthers133811303mouthers
nether94014163nether_
nonhero1057913nonhero
norther1039733norther_
northern1145583northern
northers1139333northers
nosher94616363nosher_
noshers103614333noshers
notcher123610933notcher_
notchers13279423notchers
noter55025643not_er_
noters64021003not_ers
nowhere1337213nowhere
ocher104516103_ocher_
ochers113915303_ochers
ochery14319443_ochery
ootheca1244003ootheca
otter54423973_otter_
otters64021513_otters
panther12611443panther_
panthers13510783panthers
patcher143515143patcher_
patchers153413303patchers
pater74740723pat_er_
paters84935833pat_ers
patter84628263patter_
pattern93712053pattern
patters94825193patters
patzer173111643patzer_
patzers184210573patzers
peter74427593pet_er_
peters86624593pet_ers
petter83924773petter_
petters93722363petters
pisher114317753pisher_
pishers123815753pishers
pitcher143813713pitcher_
pitchers153211483pitchers
pithead13419593pithead
pithed124615613pithe_d
pithier123010293pithier_
pitier84019823pitier_
pitiers93812653pitiers
plotter94113663plotter_
plotters104011553plotters
poacher143912323poacher_
poachers152910763poachers
pochard1537363pochard
poiser84217243poiser_
poisers94214433poisers
poker115122883po_ker_
pokers124617923po_kers
pokier124914633pokier_
polder94019253polder_
polders103617373polders
poler74431793po_ler_
polers84225643po_lers
poller83921853poller_
pollers93420023pollers
ponder94521693ponder_
ponders103618843ponders
poohed123912523poohe_d
pooler83819843pooler_
poolers94217423poolers
poorer82613993poorer_
popery134511703po_pery
popper93615963popper_
poppers103414863poppers
porker124917543porker_
porkers134314933porkers
porter84224413porter_
porters93722703porters
portiere1038773portiere
poser75128773po_ser_
posers84223973po_sers
poshest12312423poshest
poster84129173poster_
postern93615613postern
posters93928013posters
postheat13411243postheat
poteen83514263pot_een
poteens92910883poteens
potent84223353pot_ent
potheads14298543potheads
potheens13266483potheens
pothering151911283pothering
pothole12312173pothole
pothook1656883pothook
pothos114214693poth_os
potmen102713093potme_n
potshard1444533potshard
potsherds1544023potsherds
potted94624013potte_d
potteen9319673potteen
pottered112311663pottered
potterer102310263potterer
pottier93516493pottier_
pourer84516043pourer_
pourers93513673pourers
pouter83923983pouter_
pouters94221873pouters
poutier93215323poutier_
powder123611903powder_
powders134111553powders
powdery16396123powdery
power105325953po_wer_
powers113822323po_wers
powter114116033powter_
powters124015663powters
poxier153812113poxier_
preverb14317063preverb
proverb14378213proverb
pusher114318283pusher_
pushers123814503pushers
putter83921443putter_
putters94219193putters
rather94319743rather_
rotter64325463rotter_
rotters74421393rotters
smother123510213smother_
smothers13349933smothers
smothery16296063smothery
soother104215043soother_
soothers113913433soothers
souther104116303souther_
southern11438913southern
southers114214453southers
spotter94514883spotter_
spotters104313383spotters
tether93716103tether_
tethers103815313tethers
there87527393__there
therm106018023__therm
tither94920283tither_
tithers104216733tithers
tocher114014913tocher_
tochers123413093tochers
toter55932133tot_er_
toters65026363tot_ers
totter65021463totter_
totters74618733totters
tottery10388483tottery
voter85121053vot_er_
voters95017443vot_ers
wether123315393wether_
wethers135214693wethers
wither124321353wither_
withers134417753withers
wuther124511613wuther_
wuthers133711523wuthers
zither183813083zither_
zithern19447023zithern
zithers193911973zithers

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272576.95319276.1
3Display Results2572570.0962677.1
 (SQL Overall)1786912577.45523969.3
 
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.