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

192 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
omen6682818(None) 
amen66733151amen
men59252841_men
nomen75621621nomen
omens75618961omens
omer67028391omer
open66427001open
oven76624141oven
oxen116218591oxen
women104619251women
admen84516182admen
amend85717752amend
amens75624842amens
ament76036542ament
amin66042252amin
axmen145112272axmen
been65335782been
ben56554922_ben
bowmen1399852bowmen
bren65629562bren
coden86128542coden
come87547702come_
comer95832692comer
comes97246992comes
comet95946072comet
copen94826432copen
coven106925042coven
cowmen13810922cowmen
cozen165019702cozen
den47554342_den
dolmen93911372dolmen
dome77240732dome_
domed95423262domed
domes85735562domes
doven94718552doven
doyen95014412doyen
dozen155017472dozen
eme55837182eme_
emend86214892emend
emes65434662emes
emeu66723432emeu
en28052392__en
even75222272even
eyen76223662eyen
fen66851352_fen
foemen11310522foemen
foment113718302foment
gaen57329602gaen
gen45950512_gen
gien56330022gien
glen56027202glen
gomer85220652gomer
haen76229452haen
hen67555272_hen
home98042442home_
homed115425422homed
homer105828452homer
homes106938812homes
homey135924842homey
hosen85623882hosen
hymen13311042hymen
jomon14610082jomon
keen84830402keen
ken76343982_ken
lien45339802lien
limen75426032limen
loden66621142loden
lomein8410202lomein
loment84021472loment
lumen75220902lumen
man57465852_man
me47748332_me_
mean65538082_mean
med66146742_med
meg66040952_meg
mel56047482_mel
mem77943472_mem
mend75334022_mend
meno66031352_meno
menu65130222_menu
met56072432_met
mew86137732_mew
mien65028362mien
moan65832012moan
mome85239352mome_
moment103319682moment
momes95134472momes
mon57561572_mon
moon67140812moon
morn66237562morn
mown95424442mown
mun56143852_mun
nome66038422nome_
nomes74933122nomes
nonmen8412832nonmen
numen74216792numen
oaken95814382oaken
oaten55222402oaten
obe56638642obe_
obes66036832obes
obey96521302obey
ocean71212962ocean
ode47446582ode_
odea56224572odea
odeon6411482odeon
odes57243242odes
oe28473062o_e_
oes35866192o_es
often84611412often
ogee57629882ogee
ohed87825182ohed
oilmen848312oilmen
oke75839482oke_
okeh114615322okeh
okes84936342okes
olden65114852olden
ole37155212ole_
olea46532722olea
olein5316002olein
oleo46630482oleo
oles46453472oles
om48553002om__
omber95316442omber
omega836382omega
omened93711002omened
omenta83411722omenta
omers76923192omers
omit65337372omit
oms56337512om_s
on28057182o__n
one37050912one_
ones46146532ones
ope56845242ope_
oped76230152oped
opens76118552opens
opes65942612opes
ore36661832ore_
ores46056682ores
ormer75218372ormer
ose38147342ose_
oses46641512oses
ovens86217452ovens
over77227342over
owe67041032owe_
owed86833872owed
owes75137102owes
own66429702o_wn
owsen84210192owsen
oxes116530722oxes
oyer75927652oyer
oyes74940132oyes
oyez166020352oyez
peen65938082peen
pen56558842_pen
pome85636692pome_
pomes94833932pomes
potmen102713092potmen
ramen75625192ramen
rodmen939712rodmen
roman75424822roman
romeo73719702romeo
rouen54920902rouen
roven85521972roven
rowen84921152rowen
rumen74419502rumen
seen46943122seen
semen75724102semen
sen36058522_sen
smew95017732smew
socmen1039192socmen
soman75024902soman
some66040382some_
teen45938202teen
ten35856112_ten
then78429692then
token95419312token
toman75724052toman
tome67543192tome_
tomes76037382tomes
vimen104114752vimen
vomer105517382vomer
ween75835462ween
wen66249602_wen
when105723042when
woken124614972woken
woman105818002woman
womyn13426362womyn
woven115215172woven
wren78221682wren
yamen104115182yamen
yen66847382_yen
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 Filter178691298720.1401276364.3
2DLD Change Limit298721921.28323282.9
3Display Results1921920.0464173.9
 (SQL Overall)1786911921.469121641.3
 
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.