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

268 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
skymen153531(None) 
skyman1535311skyman
baymen134212002baymen
flymen14387772flymen
hymen13311042_hymen
laymen113010842laymen
seamen84518562seamen
semen75724102s_emen
skeen94817402sk_een
skyed13529922sky_ed
skyey15537222sky_ey
socmen1039192socmen
sokemen1337052sokemen
stamen84115942stamen
syren85216742s_yren
acumen1049013acumen
admen84516183_admen
aidmen92610373aidmen
airmen82612353airmen
amen66733153__amen
ashmen1168173ashmen
axemen1547493axemen
axmen145112273_axmen
badmen114613833badmen
bagmen115412533bagmen
barmen105418533barmen
batmen104414303batmen
bayman133712703bayman
bogymen1534763bogymen
bowmen1399853bowmen
busmen1039893busmen
cabmen123610653cabmen
carmen104019343carmen
cayman133613213cayman
chyme156512503chyme_
chymes165912153chymes
cowmen13810923cowmen
cyme119420373_cyme_
cymene1377393_cymene
cymes1210118923_cymes
daimen92210573daimen
daysmen1335083daysmen
deskmen1435023desk_men
dolmen93911373dolmen
doyen95014413doy_en
draymen1335233draymen
etymon1134693etymon
examen1538283examen
eyen76223663_ey_en
flamen115215993flamen
flyman14326423flyman
foemen11310523foemen
gagmen103910413gagmen
gasmen93111563gasmen
germen9612313germen
gunmen9348723gunmen
hitmen11239193hitmen
hoyden13328933hoyden
hymens1437993_hymens
hymn12311313_hym_n
icemen1037893icemen
jurymen1943133jurymen
kame105728233_kame_
kames115024693_kames
keen84830403_k_een
ken76343983_k__en
kye107327273_ky_e_
kyes115124933_ky_es
kyte117017763_kyte_
kytes125012913_kytes
lawmen11308593lawmen
layman113511303layman
legmen939343legmen
limen75426033_limen
lumen75220903_lumen
madmen113511743madmen
men59252843___men
mermen10813813mermen
nomen75621623_nomen
nonmen8412833nonmen
numen74216793_numen
oilmen848313oilmen
omen66828183__omen
oxygen1743313oxygen
payment14310703payment
penmen10311493penmen
pikemen1535333pikemen
pitmen102510793pitmen
potmen102713093potmen
premen105017803premen
ragmen93712183ragmen
ramen75625193_ramen
rhyme13479553rhyme_
rhymed15416713rhymed
rhymer14387083rhymer
rhymes14419823rhymes
rodmen939713rodmen
rumen74419503_rumen
sadden83212403sadden
sagamen10127503sagamen
saimin8313663saimin
salmon84614183salmon
same65245643s_ame_
samek114915273s_amek
sandmen1039413sandmen
sarment9318763sarment
sarsen6314233sarsen
sateen63815013sateen
sayed96127143say_ed
sayer84926553say_er
screen85216013screen
seaman84015903seaman
seamed94823883seamed
seamer84223613seamer
seedmen1037683seedmen
seemed95117613seemed
seemer84418043seemer
seen46943123s__een
segment10312563segment
seme65836653s_eme_
semens84616963s_emens
semes75731583s_emes
sen36058523s___en
sermon8413553sermon
seven84118313s_even
shaken134113613shaken
shaman113314273shaman
shame105726703shame_
shamed125120213shamed
shames114726223shames
shapen114414653shapen
shaven124213303shaven
sheen85023313s_heen
shipmen14317283shipmen
shopmen14277193shopmen
showmen15227163showmen
shyer114714783shy_er
sicken124615253sicken
sidemen1037943sidemen
siemens938413siemens
silken104410853silken
simmer104115353simmer
siren54525823s_iren
sitten64113823sitten
skate94721543skate_
skated114414873skated
skater105015483skater
skates104219393skates
skean94415623sk_ean
skeane104611373skeane
skee85431473sk__ee
skeed105018983sk_eed
skeens103912913sk_eens
skees95023123sk_ees
skeet95429183sk_eet
skeg95316163sk__eg
skein94814403sk_ein
skene96118123sk__ene
skenes104616633skenes
skep105219353sk__ep
skew116218763sk__ew
skewed145610233skewed
skewer13519603skewer
skied104417753sk_ied
skier95119593sk_ier
skies95026833sk_ies
skiey125012893sk_iey
skim105322493skim__
skimmed16306053skimmed
skimmer15327533skimmer
skimo116312533skim_o
skimos12548803skimos
skimp135411313skim_p
skimped16256223skimped
skimps14488043skimps
skimpy17475723skimpy
skims114517183skim_s
skin85927523sk__in
skite95120043skite_
skited114313473skited
skites104418033skites
skive124614113skive_
skived14429893skived
skiver134612103skiver
skives134113943skives
sklent103614353sk_lent
sky106420993sky___
skybox2242293skybox
skycap1742913skycap
skying14399983skying
skyline1436793skyline
skylit1338273skylit
skyway1933343skyway
slime74925753slime_
slimed94915123slimed
slimes84722043slimes
sloven9389633sloven
slyer85515123sly_er
slype105112363slype_
slypes114410483slypes
smew95017733s__mew
snowmen12246153snowmen
snye77115493sny_e_
snyes85012753sny_es
sockmen1535453sockmen
socman1039813socman
sodden84011513sodden
soften9429493soften
sokeman1337263sokeman
solemn838643solemn
soman75024903s_oman
some66040383s_ome_
soybean1243953soybean
spleen8310263spleen
spoken124610003spoken
spume95817313spume_
spumed114711543spumed
spumes1021314883spumes
stamens93411483stamens
stime76521793stime_
stimes85920573stimes
stolen64315063stolen
stye76218973sty_e_
styed95815483sty_ed
styes86316523sty_es
style85519363style_
styled105613103styled
styler94013303styler
styles94418653styles
stylet94018573stylet
stymie1137623stymie
stymied1335653stymied
stymies1239213stymies
stymy13358293stym_y
styrene10116693styrene
submenu1148363submenu
sudden83310833sudden
sullen62914293sullen
summed114014043summed
summer104017713summer
summon1037623summon
sunken103511783sunken
surfmen1235993surfmen
swagmen1334973swagmen
sweven1235983sweven
syce95820283s_yce_
sycee105018623s_ycee
syces106416463s_yces
syke115420563s_yke_
sykes124816863s_ykes
syn67024123s_y__n
syne75725763s_yne_
syrens94911993s_yrens
taxmen15367443taxmen
tegmen988403tegmen
thyme134612473thyme_
thymes144810743thymes
thymey17426313thymey
tinmen82310393tinmen
titmen8239883titmen
vanmen1138403vanmen
vimen104114753_vimen
women104619253_women
yamen104115183_yamen
yen66847383__y_en
yeomen1138183yeomen
zyme1819114943_zyme_
zymes1924712943_zymes

Search took 5 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 Filter1786911127160.1401276364.3
2DLD Change Limit1127162684.40625582.4
3Display Results2682680.0932881.7
 (SQL Overall)1786912684.63938519.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.