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

168 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
nowhere133721(None) 
nowheres1437511nowheres
anywhere1742562anywhere
cohere112716992co_here
cowherb1735102cowherb
cowherd1636952cowherd
nonheme1247132nonheme
nonhero1057912nonhero
nosher94616362nosher_
noshers103614332noshers
nother93815962nother_
towhee122613882towhe_e
where117019422__where
adhere10310333_adhere
another10289153another_
anywheres1842343anywheres
bother115218063bother_
bothered142110393bothered
bothers124317753bothers
bower107328183bow_er_
bowered133113043bow_ered
bowers115523703bow_ers
bowery146012113bow_ery
bowhead1636433bowhead
bowler114217313bowler_
bowlers123715783bowlers
bowyer14368923bowyer_
bowyers15438733bowyers
cohered133514693co_hered
coherer122912783co_herer
coheres122917693co_heres
coinhere1337133coinhere
compere134616623compere
cosher114819903cosher_
coshered14610293coshered
coshers123618183coshers
cower104531773cow_er_
cowered133214653cow_ered
cowers114625533cow_ers
cowhage1636303cowhage
cowherbs1833543cowherbs
cowherds1735423cowherds
cowhide1636143cowhide
cowier113616163cowier_
dinothere1344113dinothere
dower95027703dow_er_
dowered122811553dow_ered
dowers104523293dow_ers
dowery134311663dow_ery
downer104414923downer_
downers113912773downers
dowser104716083dowser_
dowsers115013533dowsers
ensphere1366083ensphere
fowler123712583fowler_
fowlers133411203fowlers
gopher1239183gopher_
gophers1338983gophers
here76447103___here
howler123514313howler_
howlers133312353howlers
inhere9313713_inhere
insphere1355973insphere
isothere1145793isothere
josher164312963josher_
joshers174111593joshers
knower1337083know_er_
knowers1436353know_ers
kosher134412973kosher_
koshered1636063koshered
koshers144811803koshers
lower85830413low_er_
lowered112711913low_ered
lowers94624923low_ers
lowery124112713low_ery
mosher114719793mosher_
moshers124017843moshers
mother113718643mother_
mothered142310103mothered
mothers123717623mothers
mothery153710513mothery
mower104523453mow_er_
mowers113219403mow_ers
nether94014163nether_
newer85717463new_er_
ngwee9311073ngw_e_e
nigher103612753nigher_
nobler83713453nobler_
nodder84811943nodder_
nodders94410263nodders
noncore9411953noncore
nonheroes1247633nonheroes
nonhome1248833nonhome
nonwhite1445703nonwhite
nonzero1646123nonzero
nooser65517823nooser_
noosers74913923noosers
noosphere1444773noosphere
norther1039733norther_
northern1145583northern
northers1139333northers
noshed104413503noshe_d
noshes96618233noshe_s
nosier63716323nosier_
notcher123610933notcher_
notchers13279423notchers
noter55025643no_ter_
noters64021003no_ters
nowise9511073now_ise
nowness1037033nowness
ocher104516103_ocher_
ochered132610283_ochered
ochers113915303_ochers
ochery14319443_ochery
ochre103411593_och_re
onshore10310013onshore
oosphere1355993oosphere
other84219103_other_
others93918003_others
owner84613313_owner_
owners94210703_owners
posher115018163posher_
pother113818853pother_
potherb14358683potherb
pothered142311043pothered
pothers123818623pothers
powder123611903powder_
powdered15256893powdered
powderer14245593powderer
powders134111553powders
powdery16396123powdery
power105325953pow_er_
powered132911643pow_ered
powers113822323pow_ers
powter114116033powter_
powters124015663powters
rower85430493row_er_
rowers94924573row_ers
snowier1038793snowier_
somewhere1742483somewhere
sower85229313sow_er_
sowers94923443sow_ers
sphere113313663_sphere
there87527393__there
tocher114014913tocher_
tochered1437913tochered
tochers123413093tochers
torchere1347683torchere
tother94117143tother_
tower85729203tow_er_
towered112911403tow_ered
towers94423673tow_ers
towery124012093tow_ery
towhead1435223towhead
towhees13277793towhees
townee92815213towne_e
unsphere1355853unsphere
vower115220793vow_er_
vowers124317183vow_ers
were76238333__w_ere
whee105429593__whe_e
wheres125917433__wheres
wherve15568113__wherve
whore116018043__whore
wowser125110203wowser_
wowsers13488763wowsers
yowler123310043yowler_
yowlers13328923yowlers

Search took 9 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.423422437.4
2DLD Change Limit1340271687.54617761.3
3Display Results1681680.1261333.3
 (SQL Overall)1786911688.09522074.2
 
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.