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

119 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
noniron73837(None) 
gonion73612832goni_on
monuron937462monuron
nonagon847312nonagon
nonpros937472nonpros
notion64516582noti_on
onion54320972_oni_on
ronion63315642roni_on
amnion84812053amni_on
andiron848283andiron
anion55028813_ani_on
benison937123benison
bonbon10310073bon_bon
bonito8313433bonito_
bonitos939733bonitos
boron76727143bo__ron
bunion83111313buni_on
confront13411603confront
conin76232723coni__n
control9310693control
dendron947653dendron
donjon1436463don_jon
environ1044763environ
eonian6311833eoni_an
fanion94514323fani_on
fenuron1075153fenuron
foison948933fo_ison
giron66118993__giron
horizon1955763horizon
ignitron943203ignitron
inion54620183_ini_on
intron64215023_intron
iron46728463___iron
linuron746513linuron
logion76013723logi_on
longeron945763longeron
lotion65716523loti_on
midiron1046003midiron
minion83416243mini_on
monaxon1644913monaxon
moneran9311113moneran
monition10311723monition
monitor9310723monitor
monsoon938493monsoon
monurons1037093monurons
morion86217733mori_on
moron76925423mo__ron
morrion959003morrion
motion85217553moti_on
nasion63914083nasi_on
nation64322803nati_on
natron64116023n_atron
nephron1246653nephron
neuron6310373n_euron
neutron737763neutron
ninon55517383__ninon
niton55418283__niton
noir46722433no_ir__
noirs55615463no_ir_s
nonagons947223nonagons
nonart6319193nonar_t
nonarts7311303nonarts
nonbook1346283nonbook
nonbrand1145383nonbrand
noncom1039683non_com
noncore9411953noncore
nondrip1046233nondrip
nondrug944103nondrug
nonego737013nonego_
nonegos837143nonegos
nonfan948293non_fan
nonfood1156653nonfood
nonfrozen2152983nonfrozen
nongreen945513nongreen
nonhero1057913nonhero_
nonillion945463nonillion
nonionic1049233noni_onic
nonjuror15113803nonjuror
nonman8412363non_man
nonmen8412833non_men
nonoral7313603nonoral
nonperson1165263nonperson
nonpoor956483nonpoor
nonprint10411413nonprint
nonproven1444723nonproven
nonstop9106923nonstop
nonunion845583nonunion
nonurban1044853nonurban
nonviral1146743nonviral
nonvirgin13112933nonvirgin
nonwool1046673nonwool
nonword1149153nonword
nonwork1448423nonwork
nonzero1646123nonzero_
noon47134623no___on
notions74014483noti_ons
omicron1165063_omicron
omikron1353173_omikron
onions64016433_oni_ons
oniony9369703_oni_ony
operon8811773_operon
orison6411663_orison
pinion83815893pini_on
poison8312223po_ison
polaron939843polaron
ponton83217643pon_ton
pontoon93010703pontoon
positron1096903positron
potion84519573poti_on
ronions73313343roni_ons
ronyon9309133ron_yon
sadiron836043sadiron
solion6616383soli_on
soliton7410233soliton
union54519793_uni_on
unison649033_unison
venison1036443venison
wanion93213063wani_on
wonton93410963won_ton

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 Limit1340271196.62620227.4
3Display Results1191190.0462587.0
 (SQL Overall)1786911197.07825246.0
 
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.