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

238 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
nonnews103531(None) 
bonnes85621452bonne_s
bonnets94812802bonnets
conners94023112conners
donnees84210362donnees
nonces84418832nonce_s
nones55639132no_ne_s
nonets64118702no_nets
nowness1037032nowness
ronnels7318612ronnels
sonnets74211992sonnets
tonners73816402tonners
tonnes65320852tonne_s
wonners104312812wonners
banners94018713banners
bannets94013843bannets
bennes86019013benne_s
bennets94712163bennets
bonders104120663bonders
boners84825433bo_ners
bones76446533bo_ne_s
boniness102211803boniness
bonkers134015303bonkers
bonne75124713bonne__
bonnet85524633bonne_t
bonzes175116103bonze_s
cannels93413363cannels
canners93822663canners
coiners93620753coiners
cones76457423co_ne_s
coneys115218423co_neys
confers124120093confers
confess12399903confess
congees103517923congees
congers104223233congers
conges94928173conge_s
conies84338593conie_s
conines93827793conine_s
conkers133721043conkers
connect113515743connect
connects123010563connects
conned95119703conne_d
conner84423963conne_r
conns75024233conn__s
contes84432913conte_s
conveys15308223conveys
corneas94717003corneas
cornels94716663cornels
corners94723313corners
cornets94820573cornets
coyness1277323coyness
cunners93913473cunners
dinners83915443dinners
donees74519493do_nees
doneness9411513doneness
donkeys15426663donkeys
donnas75511323donn_as
donne65520463donne__
donned85015743donne_d
donnee74317063donne_e
donnerd9427813donnerd
donnert82815533donnert
donzels1735393donzels
downers113912773downers
dunness8298983dunness
fanners103914653fanners
fennecs12305693fennecs
fennels10387903fennels
fondness1237213fondness
funnels10348173funnels
gannets83811443gannets
ginners84314223ginners
gonefs10439873go_nefs
goneness9310763goneness
goners74420173go_ners
gooneys11407073gooneys
gunnels8358563gunnels
gunners83111733gunners
honers94324973ho_ners
hones88144493ho_ne_s
honeys124016083ho_neys
honkers143315233honkers
honkeys17439513honkeys
hornets104113553hornets
hotness1038613hotness
inners63919353_inners
ionones7313883ionone_s
ironness836953ironness
jennets14517633jennets
joannes1436243joanne_s
joiners144211573joiners
jones125028183jo_ne_s
kennels11387193kennels
koines10415733koine_s
lanners73618333lanners
linnets739833linnets
loaners73913623loaners
loneness8512093loneness
loners64225813lo_ners
longers84819543longers
longes75925573longe_s
longness938553longness
looneys10487013looneys
lornness836493lornness
lowness1037813lowness
manners93417833manners
minnows1234913minnows
moaners92813553moaners
mondes94322353monde_s
moneys115513623mo_neys
mongers104217273mongers
monies83233163monie_s
monkeys16407423monkeys
montes84226933monte_s
mooners94015343mooners
nances83618643nance_s
nannies73015203nannies
nenes55329673n_ene_s
nephews1533323nephews
newness1035703newness
news76127373___news
nines55937343n_ine_s
ninnies73713613ninnies
nobles83319723noble_s
nodders94410263nodders
nodes64633493no_de_s
noels56418703no__els
noes45845393no__e_s
noises65021853noise_s
nomes74933123no_me_s
nominees1037363nominees
nonages8313843nonages
nonarts7311303nonarts
nonas55126653no_n_as
nonce75719823nonce__
noncoms1139203noncoms
none45743173no_ne__
nonego737013no_nego
nonegos837143nonegos
nonet54540843no_ne_t
nonfans1037533nonfans
nongays11176533nongays
nonheme1247133nonheme
nonhero1057913nonhero
noninert8415023noninert
nonmeat9312773nonmeat
nonmen8412833nonme_n
nonnovels1243443nonnovels
nonowners1245123nonowners
nonpeak1345473nonpeak
nonplus936183nonplus
nonpros937473nonpros
nonself1078513nonself
nonsense847393nonsense
nonskeds1343933nonskeds
nonusers8268003nonusers
nonuses73313863nonuses
nonwars10109003nonwars
nonyls957853no_nyls
nonzero1646123nonzero
noons54125283noon__s
noosers74913923noosers
nooses65623643noose_s
noses55435643no_se_s
noshers103614333noshers
noshes96618233noshe_s
nosiness83211393nosiness
noters64021003no_ters
notes55034583no_te_s
nounless837253nounless
nouns56717313noun__s
nouses64627163nouse_s
novels95512503no_vels
novenas1036893novenas
nows75738233no___ws
nunnery10355303nunnery
oneness7512143oneness
ones46146533_o_ne_s
onsets64013543_onsets
owners94210703_owners
panners93621273panners
pannes85522853panne_s
penners93414183penners
pinners93518603pinners
ponces104720843ponce_s
ponders103618843ponders
pones74547043po_ne_s
pongees104212543pongees
ponies84833463ponie_s
pontes83627853ponte_s
punners94114233punners
punnets9409263punnets
renews93811753_renews
rennets75212633rennets
rondels82510053rondels
ronnel63310883ronne_l
runnels7329153runnels
runners74212453runners
sennets73712583sennets
sinews94210623_sinews
sinners74019023sinners
sonders83820713sonders
sondes74922873sonde_s
sones55444143so_ne_s
sonless72612613sonless
sonnet65923503sonne_t
sonnies7315223sonnies
sooners73916643sooners
sorners73416873sorners
sundews11398153sundews
tanners74018393tanners
tenners74014923tenners
tinners73717313tinners
toners64128003to_ners
tones56048663to_ne_s
tongers84116013tongers
tonlets73212503tonlets
tonne54921433tonne__
tonneau765913tonneau
tonneaus853913tonneaus
tonner64819203tonne_r
townees10269783townees
tunnels7328723tunnels
unbonnets1143383unbonnets
unmews11326523_unmews
unsews9379363_unsews
vanners103612843vanners
wanness102610683wanness
winners104316913winners
winnows1334533winnows
woeness1020211543woeness
wonders113315993wonders
wonned104012063wonne_d
wonner95114443wonne_r
wornness1136363wornness
yonkers14379823yonkers
zoners155115993zo_ners
zones145528043zo_ne_s

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.470380193.6
2DLD Change Limit1340272386.57620381.2
3Display Results2382380.0802975.0
 (SQL Overall)1786912387.12625075.9
 
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.