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

294 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
yeoman113882(None) 
yeomen1138181yeomen
bemoan10310252bemoan
desman9311692desman
foeman11311232foeman
german9611982german
hetman112510602hetman
legman949652legman
leman75622602le_man
merman10513852merman
penman10312322penman
reman75730152re_man
roman75424822_roman
seaman84015902seaman
soman75024902_soman
teopan839352teopan
toman75724052_toman
woman105818002_woman
yean75834582ye__an
yeggman1442922yeggman
yeomanly1643212yeomanly
yeomanry1642442yeomanry
aboma91114603aboma_
abomas101113583abomas
adman84517903_adman
adwoman1345433adwoman
aeolian738623aeolian
aeon45634613aeo__n
aeonian738353aeonian
aidman92410623aidman
airman82414223airman
ajowan1634893ajowan
aroma71220143aroma_
aromas81018613aromas
ashman1148383ashman
ataman81013063ataman
atman75520143_atman
automan9310883automan
axeman1538103axeman
axman144813183_axman
badman113813843badman
bagman114613813bagman
barman103519703barman
batman105214063batman
bayman133712703bayman
beadman12249153beadman
bean66443863be__an
bedamn1137813bedamn
bedeman12168843bedeman
bedpan1137583bedpan
began86319573be_gan
bellman1137183bellman
bema85825253be_ma_
bemas96424283be_mas
bemean10410683bemean
bemoans1138253bemoans
bogan87519003_bogan
bookman15136483bookman
bowman13129853bowman
brogan9311043brogan
bromal10313653bromal
bromin102615693bromin
busman10310253busman
cabman123812503cabman
caeoma1039033caeoma_
caeomas1138393caeomas
caiman103615663caiman
carman103920743carman
cayman133613213cayman
coma87134853_coma_
comae97128423_comae
comal95125133_comal
comas95833003_comas
cotan71521783_cotan
cowman13910373cowman
crewman1435743crewman
daman84821163_daman
deadman11238423deadman
dean56039483de__an
decuman1236573decuman
deewan10267553deewan
demand104314253de_mand
demean9510563demean
demon86520313de_mon
deodand1035713deodand
deodar837713deodar
derma84918513derma_
dermal93614343dermal
dermas94116813dermas
deskman1444323deskman
desmans1039003desmans
dewan95718043de_wan
dioxan1465773dioxan
dolman95312403dolman
domain9511323_domain
domal85619203_domal
doorman1037063doorman
dromon939363dromon
elan46734243_e_lan
eolian6312593_eolian
eon36052083_eo__n
eonian6311833_eonian
eosin55220923_eosin
firman112211343firman
flyman14326423flyman
foemen11310523foemen
footman1236403footman
freeman1237343freeman
frogman1335873frogman
gagman103811243gagman
gasman92911743gasman
gemma106311773gemma_
gemmae11507793gemmae
geomancy1644153geomancy
germane1049663germane
germans1079463germans
germen9612313germen
gleeman1035363gleeman
gnomon936183gnomon
goban84414073_goban
goodman1135933goodman
gowan95415743_gowan
groan65618423gro_an
gunman9299453gunman
headman13229633headman
hemal104419803he_mal
hemin103620933he_min
herdman13238423herdman
herma105318883herma_
hermae115314473hermae
hermai118912843hermai
hetmans12187593hetmans
hexosan1744333hexosan
hitman112710213hitman
hogan97817703_hogan
honan85319773_honan
human102716033_human
iceman1037853iceman
ironman936613ironman
jean116629283je__an
jeon116821443jeo__n
jomon14610083_jomon
koan85425033_ko_an
lawman11289053lawman
layman113511303layman
laywoman1643363laywoman
leadman10237843leadman
lean46345243le__an
legmen939343legmen
lemans85316393le_mans
lemma94811033lemma_
lemmas10349163lemmas
lemon75618183le_mon
lensman937563lensman
liman75921603_liman
loan47436453_lo_an
logan68123283_logan
loran55925093_loran
madman113712383madman
man57465853___man
mean65538083me__an
meatman1137903meatman
median94117543median
mermen10813813mermen
mesian84315503mesian
messan83912063messan
messman1137283messman
moan65832013_mo_an
myeloma1444033myeloma_
myelomas1544323myelomas
myoma1239273myoma_
myomas1338293myomas
myxoma2043943myxoma_
myxomas2153903myxomas
nema65522523ne_ma_
nemas75321573ne_mas
neocon836713neocon
neon47026423neo__n
newsman1245503newsman
noma67529463_noma_
nomad86016183_nomad
nomas74726413_nomas
nomen75621623_nomen
nonman8412363nonman
oilman839483oilman
omen66828183__omen
ottoman946283ottoman
outman83115033outman
overman12311463overman
pean66147173pe__an
pecan91919033pe_can
pechan13511543pechan
pekan111613973pe_kan
penmen10311493penmen
peon65635243peo__n
permian112612283permian
pitman102412123pitman
plowman1444933plowman
potman102813573potman
preman104117453preman
prolan8414693prolan
propman1339063propman
ptomain1146963ptomain
ragman94013713ragman
redan66125013re_dan
reedman1037723reedman
regma84612333regma_
reloan6415693reloan
remain85919863re_main
remand95618963re_mand
remans84823003re_mans
remap95418103re_map
reopen8311573reopen
replan83215823replan
reran57329103re_ran
rewan85623663re_wan
roan47234203_ro_an
rodman949713rodman
romano84912943_romano
romans84620243_romans
rowan85418733_rowan
ryokan1353753ryokan
seamen84518563seamen
seawan94111223seawan
sedan65620423se_dan
seedman1037373seedman
seitan62613233seitan
semen75724103se_men
sermon8413553sermon
sewan85921293se_wan
sextan13389643sextan
shaman113314273shaman
shopman14247253shopman
shoran94016033shoran
showman15257283showman
skyman1535313skyman
slogan7539223slogan
snowman12226623snowman
socman1039813socman
solan55328153_solan
soma65635293_soma_
somans84619303_somans
somas76030373_somas
stoma75918273stoma_
stomal85213313stomal
stomas84816323stomas
taxman15328613taxman
tegmen988403tegmen
teleman959573teleman
teopans939203teopans
tinman82411123tinman
titman82710993titman
tolan55124013_tolan
tomans85419133_tomans
unman72715423_unman
vanman1139793vanman
vegan95114153ve_gan
vermian12329713vermian
vermin113414523vermin
wean75734353we__an
womans114613653_womans
women104619253_women
womyn13426363_womyn
woodman1336313woodman
woolman1235433woolman
yamen104115183y_amen
yamun10419273y_amun
yardman1335913yardman
yasmak1534593yasmak
yea66445753ye__a_
yeah106725413ye__ah
yeans86624883ye__ans
year76534253ye__ar
yearn86316433ye_arn
yeas78638423ye__as
yeelin939343yeelin
yeggmen1442673yeggmen
yen66847383ye___n
yenta83917043yenta_
yentas94614213yentas
yerba101010763yerba_
yerbas11119293yerbas
yoga87418053y_oga_
yogas96615603y_ogas
yogin98317743y_ogin
yom88043443y_om__
yomim12510073y_omim
yon67348953y_o__n
yourn87512773y_ourn
yuan76120013y__uan
yulan8411493y_ulan
zygoma2143493zygoma_
zygomas2243413zygomas
zymosan2143803zymosan

Search took 8 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.283631417.0
2DLD Change Limit1127162947.28015483.0
3Display Results2942940.0933161.3
 (SQL Overall)1786912947.65623340.0
 
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.