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

118 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
women10461925(None) 
nomen75621621nomen
omen66828181_omen
woken124614971woken
woman105818001woman
womyn13426361womyn
woven115215171woven
admen84516182admen
adwomen1345682adwomen
amen66733152_amen
awoken13457162awoken
axmen145112272axmen
bowmen1399852bowmen
coden86128542coden
come87547702come_
comer95832692comer
comes97246992comes
comet95946072comet
copen94826432copen
coven106925042coven
cowmen13810922cowmen
cozen165019702cozen
dolmen93911372dolmen
dome77240732dome_
domed95423262domed
domes85735562domes
doven94718552doven
doyen95014412doyen
dozen155017472dozen
foemen11310522foemen
foment113718302foment
gomer85220652gomer
home98042442home_
homed115425422homed
homer105828452homer
homes106938812homes
homey135924842homey
hosen85623882hosen
hymen13311042hymen
jomon14610082jomon
limen75426032limen
loden66621142loden
lomein8410202lomein
loment84021472loment
lumen75220902lumen
men59252842__men
mome85239352mome_
moment103319682moment
momes95134472momes
nome66038422nome_
nomes74933122nomes
nonmen8412832nonmen
numen74216792numen
omens75618962_omens
omer67028392_omer
open66427002_open
oven76624142_oven
owsen84210192owsen
oxen116218592_oxen
pome85636692pome_
pomes94833932pomes
potmen102713092potmen
ramen75625192ramen
rodmen939712rodmen
roman75424822roman
romeo73719702romeo
rouen54920902rouen
roven85521972roven
rowen84921152rowen
rumen74419502rumen
semen75724102semen
socmen1039192socmen
soman75024902soman
some66040382some_
token95419312token
toman75724052toman
tome67543192tome_
tomes76037382tomes
vimen104114752vimen
vomer105517382vomer
waken124818472waken
wame95035482wame_
wames106432802wames
waxen154911812waxen
ween75835462w_een
wen66249602w__en
wheen115016052wheen
when105723042w_hen
widen94717972widen
wizen175813862wizen
woe66651242wo_e_
woes76440662wo_es
woke115527962woke_
womans114613652womans
womb117022232wom_b
wombed14419232wombed
wombs125813342wombs
womby155910092womby
womera11137592womera
won66252062wo__n
wooden103610302wooden
woodmen1356052woodmen
wooed94419872wooed
wooer84316692wooer
woolen93111372woolen
woolmen1234972woolmen
wore77144672wore_
workmen1635932workmen
wormed124314302wormed
wormer114514912wormer
worn75631752wo_rn
worsen95513872worsen
wove105624312wove_
wovens12449832wovens
wowed124023772wowed
wren78221682w_ren
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.0931921408.6
2DLD Change Limit538001181.68631909.8
3Display Results1181180.0333575.8
 (SQL Overall)1786911181.81298615.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.