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

453 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
ragman9401371(None) 
bagman114613811bagman
gagman103811241gagman
raglan73711501raglan
ragmen93712181ragmen
adman84517902_adman
agma77623262_agma_
agmas85919872_agmas
atman75520142_atman
axman144813182_axman
badman113813842badman
bagmen115412532bagmen
barman103519702barman
batman105214062batman
bayman133712702bayman
cabman123812502cabman
caiman103615662caiman
carman103920742carman
cayman133613212cayman
cragsman1345212cragsman
daman84821162da_man
dragoman1244652dragoman
drayman1335432drayman
flagman13186172flagman
frogman1335872frogman
gagmen103910412gagmen
gasman92911742gasman
hangman1337792hangman
lagan66520342lag_an
lawman11289052lawman
layman113511302layman
legman949652legman
madman113712382madman
magian9312832magian
magma104513572magma_
magmas115512502magmas
pagan86121162pag_an
radian74117272radian
raga55930812rag_a_
ragas65326062rag_as
ragbag1045462ragbag
raglans82410132raglans
ragtag836642ragtag
ramal74622242ra_mal
ramen75625192ra_men
randan7315252randan
ratan53722662ra_tan
rattan63613602rattan
regma84612332regma_
reman75730152r_eman
rodman949712rodman
roman75424822r_oman
sagaman10117552sagaman
swagman1334912swagman
taxman15328612taxman
vanman1139792vanman
admen84516183_admen
afghan1333873afghan
aga410447233_ag_a_
again65218113_again
agama85815573_agama
agamas97413443_agamas
agar58726413_ag_ar
agas55938843_ag_as
agha87417303_agha_
aghas97014873_aghas
agin56132713_ag_in
agon56531883_ag_on
aidman92410623aidman
airman82414223airman
alan46844083_a_lan
alma66333023_alma_
almah106917253_almah
almas76629773_almas
ama510853303_a_ma_
amah98927483_a_mah
amain74922883_a_main
amas67746293_a_mas
amen66733153_a_men
amin66042243_a_min
apian75018333_apian
argal65023383arg_al
argon65520593arg_on
aroma71220143aroma_
aromas81018613aromas
ashman1148383ashman
ataghan1144653ataghan
ataman81013063ataman
atma68121773_atma_
atmans84413963_atmans
atmas75721013_atmas
avian84616053_avian
axeman1538103axeman
axmen145112273_axmen
azan136521783_a_zan
badmen114613833badmen
banian8315383banian
banyan1139483banyan
bargeman1345143bargeman
barmen105418533barmen
baseman1138553baseman
batmen104414303batmen
batsman1157993batsman
baymen134212003baymen
beadman12249153beadman
began86319573beg_an
boatman1147053boatman
bogan87519003bog_an
bogyman1544933bogyman
bowman13129853bowman
brahma1336193brahma_
brahmas1436733brahmas
brakeman1644313brakeman
bregma1134963bregma_
brogan9311043brog_an
busman10310253busman
cabmen123610653cabmen
caftan111710123caftan
caimans113811783caimans
callan83619603callan
camas96333523ca_mas
cancan10314103cancan
captan101613343captan
carmen104019343carmen
caveman1437073caveman
caymans14349513caymans
chapman1637893chapman
cowman13910373cowman
cragsmen1344763cragsmen
crewman1435743crewman
daemon9279593daemon
dagga839543dagga_
daggas937973daggas
daimen92210573daimen
daimon9259713daimon
damans94715983da_mans
damar84117733da_mar
dammar11438903dammar
damn75724323da_m_n
daysman1335053daysman
deadman11238423deadman
desman9311693desman
dogma96112463dogma_
dogmas105011243dogmas
dolman95312403dolman
dragomans1343323dragomans
dragomen1245013dragomen
dragon838843drag_on
dragoon935283dragoon
drama85117413dra_ma_
dramas95814653dra_mas
draymen1335233draymen
fagin9216573fag_in
firman112211343firman
flagmen13226913flagmen
flyman14326423flyman
foeman11311233foeman
fragment1448373fragment
fragrant1247113fragrant
freeman1237343freeman
frogmen1335893frogmen
gaga66625553gag_a_
gama77035513ga_ma_
gamas85431353ga_mas
gamay116419103ga_may
gamin84422993ga_min
gamma106116103gamma_
gammas115714693gammas
gammon1138903gammon
gan48060123__g_an
garageman1382913garageman
gasmen93111563gasmen
gateman1057463gateman
german9611983german
grama85620283gra_ma_
gramas94317203gra_mas
gramma11499803gramma_
grammar12406893grammar
grammas12499773grammas
gran56335013__gran
gripman1234463gripman
guan55325583__guan
gunman9299453gunman
hackman1836433hackman
haemal113811643haemal
haemin113412663haemin
hagdon1188283hagdon
halma108219253halma_
halmas117017893halmas
hamal104623103ha_mal
hammal134512063hammal
hammam12419333hammam
hangmen1337373hangmen
hanuman1237123hanuman
harmin113117393harmin
hazan173813613ha_zan
hazmat20312263hazmat
hazzan17236803hazzan
headman13229633headman
hetman112510603hetman
hitman112710213hitman
hogan97817703hog_an
hogmane1336333hogmane
human102716033_human
iceman1037853iceman
ironman936613ironman
jagra1338173jagra_
jagras1438463jagras
jaguar1435283jaguar
japan14411233ja_pan
jasmin1538073jasmin
jawan15710383ja_wan
jazzman2442553jazzman
kaftan13185823kaftan
kalian10312163kalian
kanban1238623kanban
karma113415003karma_
karmas123013733karmas
lagans75717783lag_ans
lagoon7410483lagoon
laguna7127223laguna
lallan63414173lallan
lama66635293la_ma_
lamas75532793la_mas
landman1038923landman
lauan55216793la_uan
lawmen11308593lawmen
laymen113010843laymen
leadman10237843leadman
legmen939343legmen
leman75622603_leman
ligan67920283lig_an
lignan75510323lignan
liman75921603_liman
logan68123283log_an
madmen113511743madmen
magians10310753magians
magmata1237463magmata
mailman1137733mailman
mama86231583ma_ma_
mamas95930773ma_mas
mamma86317913mamma_
mammae94613213mammae
mammal95112753mammal
mammas94616403mammas
mammon939643mammon
man57465853___man
mannan85413623mannan
mayan105616903ma_yan
meatman1137903meatman
merman10513853merman
naan47621933na__an
nagana748943nag_ana
nonman8412363nonman
oarsman937733oarsman
oilman839483oilman
organ6915393org_an
origan7310693orig_an
outman83115033outman
packman1736693packman
paean77222723pa_ean
paesan85114093paesan
pagans95717923pag_ans
pageant10312783pageant
paisan84417073paisan
palmar104113463palmar
parian83223963parian
partan83820563partan
pavan106518473pa_van
penman10312323penman
pitman102412123pitman
potman102813573potman
preman104117453preman
propman1339063propman
pygmean1542223pygmean
rabat72832223ra_bat
rabbin103112293rabbin
racial83419243racial
racon75422143ra_con
racoon83814473racoon
radar61316723ra_dar
radial74020393radial
radians83013823radians
radiant82817133radiant
radioman1145773radioman
radon64620503ra_don
raftsman1344163raftsman
rag45761323rag___
ragbags1135113ragbags
rage55742353rag__e
raged74829453rag_ed
ragee65432663rag_ee
ragees74618663ragees
rages64539443rag_es
ragg65622693rag__g
ragged94620263ragged
raggee84217603raggee
ragging103516683ragging
raggle83712883raggle
raggs75216473rag_gs
raggy106116573rag_gy
ragi56032283rag__i
raging85126433raging
ragis66325603rag_is
ragout7317183ragout
rags55448373rag__s
ragtags935373ragtags
ragtop936683ragtop
raia46638383ra_ia_
raias54631123ra_ias
raiment9315413raiment
rain46251733ra__in
raisin62716923raisin
raita54623073raita_
raitas64417673raitas
raja117918683ra_ja_
rajah155711423ra_jah
rajas127317723ra_jas
ram56867273ra_m__
ramada9310183ra_mada
ramate83921683ra_mate
ramee74633853ra_mee
ramet75743143ra_met
rami66034093ra_m_i
ramie75027823ra_mie
rammed113117303rammed
rammer103519653rammer
ramming123115063ramming
rammy124312493ra_mmy
ramona8412413ra_mona
ramp85934003ra_m_p
rampant11312173rampant
ramps96224633ra_mps
rams65950773ra_m_s
ramson8310463ramson
ramus76418283ra_mus
ran38266613r___an
ranchman1546043ranchman
randans8313213randans
raphae114311733raphae
rappen103512713rappen
rascal8511123rascal
ratal55025113ra_tal
ratans63819373ra_tans
ratany93411873ra_tany
ratbag956563ratbag
ration64226013ration
ratlin64116523ratlin
ratoon64417373ratoon
rattans73411953rattans
ratten64217383ratten
ratton64116123ratton
raven84723443ra_ven
ravin85624653ra_vin
rawin85521473ra_win
raya75224823ra_ya_
rayah116013503ra_yah
rayas85922053ra_yas
rayon83815703ra_yon
reagin74915533reag_in
redan66125013r_edan
reedman1037723reedman
regain74517763regain
regal65023793reg_al
regear73512743regear
reggae858953reggae
regimen104411573regimen
regina75317143regina
region74614903region
regmata1036193regmata
regna64614813regna_
regnal74812933regnal
regnant8312843regnant
regrant8317323regrant
reloan6415693reloan
remain85919863r_emain
remand95618963r_emand
remans84823003r_emans
remap95418103r_emap
replan83215823replan
reran57329103r_eran
rewan85623663r_ewan
roan47234203r__oan
rodmen939713rodmen
rodsman1036653rodsman
romano84912943r_omano
romans84620243r_omans
rowan85418733r_owan
ruga56121233rug_a_
rugae65114763rug_ae
rugal65916093rug_al
rumen74419503r_umen
rurban849043rurban
ryokan1353753ryokan
saga55331173sag_a_
sagamen10127503sagamen
sagas66025883sag_as
saggar84010853saggar
saimin8313663saimin
salmon84614183salmon
sampan102511893sampan
sandman10310173sandman
saran53730303sa_ran
seaman84015903seaman
shaman113314273shaman
sigma84513823sigma_
sigmas94111353sigmas
skyman1535313skyman
socman1039813socman
soman75024903_soman
swagmen1334973swagmen
taggant9310213taggant
tagrag837043tagrag
taipan82410663taipan
tamal73522613ta_mal
tampan102512323tampan
tarmac10310333tarmac
tarpan82814293tarpan
tartan64217513tartan
tarzan152910753tarzan
taximan1635783taximan
taxmen15367443taxmen
tegmen988403tegmen
tinman82411123tinman
titman82710993titman
toman75724053_toman
tongman1037553tongman
trackman1645403trackman
tragopan1144343tragopan
trainman1046223trainman
trapan82412973tra_pan
trashman1345813trashman
trauma838803trauma_
traumas938583traumas
unman72715423_unman
vagal94613633vag_al
vagina102710933vagina
vagrant11410663vagrant
vanmen1138403vanmen
vegan95114153veg_an
wadmal1237283wadmal
waggon1136393waggon
wagon94312953wag_on
wangan10311223wangan
wigan95114393wig_an
wingman1336363wingman
woman105818003_woman
yamen104115183ya_men
yamun10419273ya_mun
yardman1335913yardman
yasmak1534593yasmak
yeggman1442923yeggman
yeoman1138823yeoman

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.1401276364.3
2DLD Change Limit1127164536.09318499.3
3Display Results4534530.1403235.7
 (SQL Overall)1786914536.37328038.8
 
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.