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 “nomen” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

121 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
nomen7562162(None) 
nome66038421nome_
nomes74933121nomes
nonmen8412831nonmen
numen74216791numen
omen66828181_omen
women104619251women
admen84516182admen
agnomen1036762agnomen
amen66733152_amen
axmen145112272axmen
bowmen1399852bowmen
coden86128542coden
come87547702come_
comer95832692comer
comes97246992comes
comet95946072comet
copen94826432copen
coven106925042coven
cowmen13810922cowmen
cozen165019702cozen
dolmen93911372dolmen
dome77240732dome_
domed95423262domed
domes85735562domes
doven94718552doven
doyen95014412doyen
dozen155017472dozen
foemen11310522foemen
foment113718302foment
gnome84213952gnome_
gnomes93812972gnomes
gnomon936182gnomon
gomer85220652gomer
home98042442home_
homed115425422homed
homer105828452homer
homes106938812homes
homey135924842homey
hosen85623882hosen
hymen13311042hymen
jomon14610082jomon
limen75426032limen
loden66621142loden
lomein8410202lomein
loment84021472loment
lumen75220902lumen
men59252852__men
mome85239352mome_
moment103319682moment
momes95134472momes
name65637412name_
named85223062named
namer75622102namer
names74833362names
nocent83217412nocent
node513036882node_
nodes64633492nodes
noel45226552no_el
noes45845392no_es
nom510450642nom__
noma67529462nom_a
nomad86016182nomad
nomas74726412nomas
nomina83113682nomina
nomoi76012532nomoi
nomos75919742nomos
noms65636402nom_s
none45743172none_
nones55639132nones
nonet54540842nonet
nonman8412362nonman
noon47134622no_on
nope65934192nope_
normed95014542normed
nose46739362nose_
nosed65524552nosed
noses55435642noses
nosey85619882nosey
note46239962note_
noted65123842noted
noter55025642noter
notes55034582notes
noumena945632noumena
noun45724182no_un
novel85615992novel
novena936762novena
omens75618962_omens
omer67028392_omer
open66427002_open
oven76624142_oven
oxen116218592_oxen
pome85636692pome_
pomes94833932pomes
potmen102713092potmen
ramen75625192ramen
rodmen939712rodmen
roman75424822roman
romeo73719702romeo
rouen54920902rouen
roven85521972roven
rowen84921152rowen
rumen74419502rumen
semen75724102semen
snowmen12246152snowmen
socmen1039192socmen
soman75024902soman
some66040382some_
token95419312token
toman75724052toman
tome67543192tome_
tomes76037382tomes
unopen838912unopen
vimen104114752vimen
vomer105517382vomer
woken124614972woken
woman105818002woman
womyn13426362womyn
woven115215172woven
yamen104115182yamen
yeomen1138182yeomen

Search took 2 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 Filter178691538000.296603685.8
2DLD Change Limit538001211.50035866.7
3Display Results1211210.0333666.7
 (SQL Overall)1786911211.82997698.7
 
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.