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

146 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
omens7561896(None) 
amens75624841amens
omen66828181omen_
omers76923191omers
opens76118551opens
ovens86217451ovens
amen66733152amen_
amend85717752amend
amends94713282amends
ament76036542ament
aments85219802aments
amins75534322amins
avens86419332avens
bens65945702_bens
brens75823362brens
codens94821012codens
comers105328082comers
comes97246992come_s
comets105823582comets
copens106119962copens
covens114919262covens
cozens176314922cozens
dens55945072_dens
dolmens10388692dolmens
domes85735562dome_s
dovens104413902dovens
doyens104810222doyens
dozens164612462dozens
emend86214892emend
emends95711432emends
emes65434662eme_s
emeus76913332emeus
ens37245922__ens
evens84817102evens
fens76139762_fens
foment113718302foment
foments122912052foments
gens55740072_gens
glens66519852glens
gomers94116882gomers
hens75642572_hens
homers114821972homers
homes106938812home_s
homeys145012872homeys
hymens1437992hymens
keens95721182keens
kens85435232_kens
lens46146492_lens
liens56525502liens
limens84618032limens
lodens74315062lodens
lomeins969472lomeins
loment84021472loment
loments93413472loments
lumens85013972lumens
mans66354532_mans
means75831222_means
meds75735362_meds
megs75530632_megs
mels65941532_mels
mems85931502_mems
men59252842_men_
mend75334022_mend
mends84927692_mends
meno66031352_meno
mensa75318662_mensa
mense75025632_mense
mensh105413552_mensh
menu65130222_menu
menus75822842_menus
mess65932432_mess
mews96629332_mews
miens76118302miens
moans74624362moans
moment103319682moment
moments113113122moments
momes95134472mome_s
mons68152252_mons
moons75331002moons
morns75527442morns
muns65535912_muns
nomen75621622nomen_
nomes74933122nome_s
obes66036832obe_s
obeys107010642obeys
oceans81211002oceans
odeons739022odeons
odes57243242ode_s
oes35866192o_e_s
ogees65119142ogees
okehs12477462okehs
okes84936342oke_s
oleins6313522oleins
oleos55419682oleos
oles46453472ole_s
ombers104214402ombers
omega836382omega
omegas936972omegas
omened93711002omened
omenta83411722omenta
omer67028392ome_r
omits75018262omits
oms56337512om__s
ones46146532one_s
ons36148512o__ns
open66427002open_
opes65942612ope_s
ores46056682ore_s
ormers84316142ormers
oses46641512ose_s
oven76624142oven_
overs85224792overs
owes75137102owe_s
owns76819582o_wns
oxen116218592oxen_
oxes116530722oxe_s
oyers87620882oyers
oyes74940132oye_s
peens76428192peens
pens65649642_pens
pomes94833932pome_s
romans84620242romans
romeos84013172romeos
rouens64814442rouens
rowens94515302rowens
rumens83611812rumens
semens84616962semens
smews104612292smews
somans84619302somans
sowens93613152sowens
teens56227482teens
tens45647412_tens
thens85921832thens
tokens104711562tokens
tomans85419132tomans
tomes76037382tome_s
vomers115614942vomers
weens85224052weens
wens76337932_wens
whens114618762whens
womans114613652womans
women104619252women_
wovens12449832wovens
wrens85016242wrens
yamens114010822yamens
yens75832262_yens

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.0931921408.6
2DLD Change Limit538001461.68631909.8
3Display Results1461460.0304866.7
 (SQL Overall)1786911461.80998778.9
 
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.