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

211 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
skyman153531(None) 
skymen1535311skymen
bayman133712712bayman
cayman133613222cayman
flyman14326422flyman
layman113511312layman
seaman84015902seaman
shaman113314282shaman
skean94415622sk_ean
skycap1742912skycap
skyway1933342skyway
socman1039812socman
sokeman1337262sokeman
soman75024902s_oman
adman84517913_adman
aidman92410623aidman
airman82414233airman
ashman1148383ashman
ataman81013063ataman
atman75520153_atman
axeman1538103axeman
axman144813193_axman
badman113813853badman
bagman114613823bagman
barman103519723barman
batman105214073batman
baymen134212003baymen
bogyman1544933bogyman
bowman13129853bowman
busman10310253busman
cabman123812513cabman
caiman103615673caiman
carman103920763carman
caymans14349513caymans
cowman13910373cowman
cyan96419623_cy_an
cyma116715843_cyma_
cymae126713013_cymae
cymar125711263_cymar
cymas126417883_cymas
daman84821173_daman
daysman1335053daysman
deskman1444323desk_man
desman9311693desman
dolman95312403dolman
drayman1335433drayman
etyma1036583etyma_
etymon1134693etymon
firman112211353firman
flymen14387773flymen
foeman11311233foeman
frypan1434543frypan
gagman103811253gagman
gasman92911753gasman
german9611993german
glycan1234903glycan
gunman9299453gunman
hetman112510603hetman
hitman112710223hitman
human102716033_human
hymen13311043_hymen
hymn12311313_hym_n
iceman1037853iceman
juryman1943583juryman
khan115819153_k_han
koan85425043_k_oan
kyak105213643_ky_ak
kyar116916853_ky_ar
kyat116025533_ky_at
lawman11289063lawman
laymen113010843laymen
legman949653legman
leman75622603_leman
liman75921603_liman
madman113712393madman
man57465873___man
mayan105616903may_an
merman10513873merman
nonman8412363nonman
oilman839483oilman
outman83115033outman
penman10312323penman
pikeman1535523pikeman
pitman102412123pitman
potman102813573potman
preman104117453preman
pyran10514473_pyran
ragman94013723ragman
reman75730153_reman
rodman949713rodman
roman75424823_roman
sagaman10117563sagaman
saimin8313663saimin
salmon84614183salmon
sampan102511893sampan
sandman10310173sandman
saran53730313s_aran
scan65530453s__can
seamen84518563seamen
seawan94111223seawan
sedan65620423s_edan
seedman1037373seedman
seitan62613233seitan
semen75724103s_emen
sermon8413553sermon
sewan85921293s_ewan
sextan13389643sextan
shamans123610903shamans
shamas113717943shamas
shipman14247133shipman
shopman14247263shopman
shoran94016043shoran
showman15257293showman
siamang1045333siamang
siccan1037593siccan
sideman1037973sideman
sigma84513833sigma_
sigmas94111363sigmas
silvan92810153silvan
sima64730793s_ima_
simar74920813s_imar
simas75727553s_imas
simian8811163simian
ska76925863sk__a_
skag96321513sk__ag
skank84415583sk__ank
skas85325713sk__as
skat87037903sk__at
skeane104611373sk_eane
skeans104512913sk_eans
skeen94817403sk_een
skein94814413sk_ein
skim105322523skim__
skimo116312553skim_o
skimos12548803skimos
skimp135411333skim_p
skimps14488043skimps
skimpy17475723skimpy
skims114517203skim_s
skin85927543sk__in
skoal93811463sk_oal
skua86113153sk_ua_
skuas95611733sk_uas
sky106420993sky___
skybox2242293skybox
skycaps1842713skycaps
skyed13529923sky_ed
skyey15537223sky_ey
skying14399983skying
skyjack2242763skyjack
skylark1343273skylark
skyline1436793skyline
skylit1338283skylit
skysail1462843skysail
skywalk1642353skywalk
skyward1843863skyward
skyways2043223skyways
slogan7539223slogan
snowman12226623snowman
sockman1535663sockman
socmen1039193socmen
sokemen1337053sokemen
solan55328153s_olan
soldan73511853soldan
soma65635293s_oma_
somans84619303s_omans
somas76030373s_omas
soudan73210353soudan
sovran937153sovran
soya75724433soy_a_
soyas84520913soy_as
soybean1243953soybean
span65234663s__pan
spean74620513s_pean
stamen84115943stamen
stoma75918273stoma_
stomal85213313stomal
stomas84816323stomas
stygian1144083stygian
stylar9358113stylar
stymie1137623stymie
stymy13358293stym_y
styrax1675243styrax
suldan72611043suldan
sultan63012593sultan
sumac99514883s_umac
summa94713313summa_
summae103911013summae
summand1236263summand
summas104313163summas
summon1037623summon
suntan62613003suntan
surfman1236203surfman
swagman1334913swagman
swan76631313s__wan
sylvan12257363sylvan
syn67024123s_y__n
syren85216743s_yren
taxman15328623taxman
tinman82411143tinman
titman82711003titman
toman75724053_toman
tryma1037223tryma_
tympan13257013_tympan
unman72715423_unman
vanman1139803vanman
woman105818003_woman
xylan1537463_xylan
yean75834583__yean
yeoman1138823yeoman
yuan76120013__yuan

Search took 7 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.373479064.3
2DLD Change Limit1127162115.66019914.5
3Display Results2112110.0603516.7
 (SQL Overall)1786912116.09329327.3
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.