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

162 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
nonhero105790(None) 
nonzero1646111nonzero
montero9310122montero
nonego737012non_ego
nonheme1247132nonheme
nonheroes1247622nonheroes
nonheroic1445192nonheroic
nonmetro1045362nonmetro
nosher94616362nosher_
noshers103614322noshers
nother93815962nother_
nowhere1337202nowhere
another10289153another_
antihero1147663antihero
bolero8412093bo_lero
bonder95324783bonder_
bonders104120663bonders
boner75133083bon_er_
boners84825433bon_ers
bonier84321993bonier_
bonkers134015303bonkers
bonzer175313673bonzer_
bother115218063bother_
bothers124317753bothers
cohere112716993co_here
coinhere1337133coinhere
concern113011963concern
concert113325223concert
concerto123311613concerto
confer114018683confer_
confers124120093confers
conger95024273conger_
congers104223233congers
conker124721553conker_
conkers133721043conkers
conner84423963conner_
conners94023113conners
converso1336423converso
convert123721473convert
cosher114819903cosher_
coshers123618173coshers
cowherb1735103cowherb
cowherd1636953cowherd
dinero75612643din_ero
donnerd9427813donnerd
donnert82815523donnert
fonder104120063fonder_
goner66025163gon_er_
goners74420173gon_ers
gopher1239183gopher_
gophers1338983gophers
hero74635783___hero
honer85332093hon_er_
honers94324973hon_ers
honker134117463honker_
honkers143315233honkers
inhere9313713_inhere
josher164312963josher_
joshers174111593joshers
kosher134412973kosher_
koshers144811803koshers
loner55431043lon_er_
loners64225813lon_ers
longer75823203longer_
longeron945763longeron
longers84819543longers
monger94418333monger_
mongers104217273mongers
monkery16317453monkery
monteros1039443monteros
mosher114719793mosher_
moshers124017843moshers
mother113718643mother_
mothers123717623mothers
mothery153710513mothery
nether94014163nether_
nigher103612753nigher_
nobler83713453nobler_
nodder84811943nodder_
nodders94410253nodders
nonart6319193non_art
nonce75719823nonce__
nonces84418833nonce_s
noncore9411953noncore
none45743173non_e__
nonegos837143non_egos
nones55639133non_e_s
nonet54540843non_e_t
nonets64118703non_ets
nonfarm1246513nonfarm
nonghetto1352753nonghetto
nonhardy1544333nonhardy
nonhome1248833nonhome
noninert8415023noninert
noniron738373non_iron
nonjuror15113793nonjuror
nonjury1744023nonjury
nonmeat9312773nonmeat
nonmen8412833nonme_n
nonnews1035313nonnews
nonpar8168993nonpar_
nonpeak1345473nonpeak
nonperson1165253nonperson
nonpoor956483nonpoor
nonpros937473non_pros
nonself1078513nonself
nonuser7299143nonuser_
nonusers8268003nonusers
nonwar9159423nonwar_
nonwars10109003nonwars
nonword1149153nonword
nonwork1448423nonwork
nooser65517823nooser_
noosers74913913noosers
norther1039733norther_
northern1145583northern
northers1139333northers
noshed104413503noshe_d
noshes96618233noshe_s
nosier63716323nosier_
notcher123610933notcher_
notchers13279423notchers
noter55025643no_ter_
noters64020993no_ters
nowheres1437493nowheres
nunnery10355303nunnery
ocher104516103_ocher_
ochers113915303_ochers
ochery14319443_ochery
onery8414123_on_ery
other84219103_other_
others93918003_others
ponder94521693ponder_
ponders103618843ponders
posher115018163posher_
pother113818853pother_
potherb14358683potherb
pothers123818623pothers
ranchero13277423ranchero
santero7311133santero
sonder73623523sonder_
sonders83820713sonders
tocher114014913tocher_
tochers123413093tochers
toner55336243ton_er_
toners64128003ton_ers
tonger74719683tonger_
tongers84116013tongers
tonier65520713tonier_
tonner64819203tonner_
tonners73816403tonners
torero6313203to_rero
tother94117143tother_
wonder103617813wonder_
wonders113315993wonders
wonner95114443wonner_
wonners104312813wonners
yonder103214133yonder_
yonker134110853yonker_
yonkers14379823yonkers
zoner144520343zon_er_
zoners155115993zon_ers

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.1561145455.1
2DLD Change Limit1340271628.59315597.2
3Display Results1621620.0632571.4
 (SQL Overall)1786911628.81220278.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.