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

141 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
nonzero164612(None) 
nonhero1057911nonhero
bonzer175313672bonzer_
montero9310132montero
nonego737012non_ego
nonmetro1045372nonmetro
bolero8412093bo_lero
bonder95324783bonder_
bonders104120663bonders
boner75133083bon_er_
boners84825433bon_ers
bonier84321993bonier_
bonkers134015303bonkers
bonze165119353bonze__
bonzes175116103bonze_s
boozer174815963boozer_
boozers183912443boozers
bronzer18348493bronzer_
bronzers19296983bronzers
concern113011963concern
concert113325223concert
concerto123311613concerto
confer114018683confer_
confers124120093confers
conger95024273conger_
congers104223233congers
conker124721553conker_
conkers133721043conkers
conner84423963conner_
conners94023113conners
converso1336423converso
convert123721473convert
dinero75612643din_ero
donnerd9427813donnerd
donnert82815533donnert
donzel1636313donze_l
donzels1735393donzels
doozer163910463doozer_
doozers17419293doozers
dozer158419273do_zer_
dozers164815423do_zers
fonder104120063fonder_
goner66025163gon_er_
goners74420173gon_ers
gonzo15310243gonz__o
honer85332093hon_er_
honers94324973hon_ers
honker134117463honker_
honkers143315233honkers
ionizer162310123ionizer_
ionizers17257713ionizers
loner55431043lon_er_
loners64225813lon_ers
longer75823203longer_
longeron945763longeron
longers84819543longers
momzer19327553momzer_
momzers20367133momzers
monger94418333monger_
mongers104217273mongers
monkery16317453monkery
monteros1039453monteros
nobler83713453nobler_
nodder84811943nodder_
nodders94410263nodders
nonart6319193non_art
nonce75719823nonce__
nonces84418833nonce_s
noncore9411953noncore
none45743173non_e__
nonegos837143non_egos
nones55639133non_e_s
nonet54540843non_e_t
nonets64118703non_ets
nonfarm1246513nonfarm
nonheme1247133nonheme
nonheroes1247633nonheroes
nonheroic1445203nonheroic
noninert8415023noninert
noniron738373non_iron
nonjuror15113803nonjuror
nonjury1744033nonjury
nonmeat9312773nonmeat
nonmen8412833nonme_n
nonnews1035313nonnews
nonpar8168993nonpar_
nonpeak1345473nonpeak
nonperson1165263nonperson
nonpoor956483nonpoor
nonpros937473non_pros
nonself1078513nonself
nonuser7299143nonuser_
nonusers8268003nonusers
nonwar9159423nonwar_
nonwars10109003nonwars
nonword1149153nonword
nonwork1448423nonwork
nooser65517823nooser_
noosers74913923noosers
nosher94616363nosher_
noshers103614333noshers
nosier63716323nosier_
noter55025643no_ter_
noters64021003no_ters
nother93815963nother_
nowhere1337213nowhere
nunnery10355303nunnery
onery8414123_on_ery
panzer174213233panzer_
panzers184012013panzers
ponder94521693ponder_
ponders103618843ponders
potzer174411213potzer_
potzers184010543potzers
rezero1578873_rezero
rozzer1437353rozzer_
rozzers1535633rozzers
santero7311133santero
snoozer16409193snoozer_
snoozers17296943snoozers
sonder73623523sonder_
sonders83820713sonders
subzero1835613subzero
toner55336243ton_er_
toners64128003ton_ers
tonger74719683tonger_
tongers84116013tongers
tonier65520713tonier_
tonner64819203tonner_
tonners73816403tonners
torero6313203to_rero
wonder103617813wonder_
wonders113315993wonders
wonner95114443wonner_
wonners104312813wonners
yonder103214133yonder_
yonker134110853yonker_
yonkers14379823yonkers
zero134822473___zero
zoner144520343zon_er_
zoners155115993zon_ers

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.390458182.1
2DLD Change Limit1340271417.20318607.1
3Display Results1411410.0463065.2
 (SQL Overall)1786911417.63923391.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.