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

288 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
axeman153810(None) 
axemen1547491axemen
axman144813181ax_man
adman84517902a_dman
aidman92410622aidman
airman82414222airman
ameban1039102ameban
ashman1148382ashman
ataman81013062ataman
atman75520142a_tman
axmen145112272ax_men
baseman1138552baseman
caveman1437072caveman
foeman11311232foeman
gateman1057472gateman
iceman1037852iceman
leman75622602_leman
preman104117452preman
reman75730152_reman
taximan1635782taximan
taxman15328612tax_man
abeam9316533abe_am
abelian92810653abelian
abeyant1248083abeyant
aboma91114603aboma_
abomas101113583abomas
aceta74017353aceta_
acetal84314903acetal
acetin8314693acetin
acumen1049013acumen
adamant101110443adamant
admen84516183a_dmen
adwoman1345433adwoman
aeon45634613a_e_on
afghan1333873afghan
agama85815583agama_
agamas97413453agamas
agemate101210583agemate
agma77623263a_gma_
agmas85919873a_gmas
ahead96817053ahe_ad
ahem97225363ahem__
aidmen92610373aidmen
airmen82612353airmen
ajowan1634893ajowan
akela9311343akela_
akelas10311193akelas
alan46844083a__lan
alderman1145193alderman
alegar739283alegar
alevin92511513alevin
alexin132311483alexin
alma66333023a_lma_
almah106917253a_lmah
almas76629773a_lmas
almemar1144303almemar
almsman1145093almsman
alumin8513543alumin
alumna857343alumna
ama510853303a__ma_
amah98927493a__mah
amain74922913a__main
amas67746293a__mas
ameba9312383ameba_
amebae1049633amebae
amebas10311453amebas
amebean1144863amebean
amen66733153a__men
amin66042253a__min
amoeban1144913amoeban
anear55420323ane_ar
anemia82613573anemia
anemias92512143anemias
anemic102713693anemic
anemone9119453anemone
anima74620073anima_
animal85016253animal
animas84418723animas
antiman9313883antiman
anuran64313243anuran
apeak115513453ape_ak
apian75018333a_pian
area45843393are_a_
areae55229743are_ae
areal55928733are_al
areas55935773are_as
areca75618633areca_
arecas84817443arecas
arena55323813arena_
arenas65021993arenas
arepa75615563arepa_
arepas85515703arepas
aroma71220143aroma_
aromas81018613aromas
asea46327183ase_a_
ashcan1135843ashcan
ashmen1168173ashmen
atamans9710433atamans
atma68121773a_tma_
atmans84413963a_tmans
atmas75721013a_tmas
automan9310883automan
avellan1037303avellan
avian84616053a_vian
axal116520493ax__al
axe108239493axe___
axed128829613axe__d
axel115222073axe__l
axels126313633axe_ls
axenic154210003axenic
axes117337853axe__s
axial124515193ax_ial
axion1211316913ax_ion
axon115524303ax__on
axonal1347653axonal
axonemal1743543axonemal
azan136521783a__zan
badman113813843badman
bagman114613813bagman
bargeman1345143bargeman
barman103519703barman
basemen1139083basemen
batman105214063batman
batsman1157993batsman
bayman133712703bayman
bean66443863_be_an
bedeman12168843bedeman
began86319573_began
bema85825253_bema_
bemas96424283_bemas
bemean10410683_bemean
bemoan10310253_bemoan
bowman13129853bowman
brakeman1644313brakeman
busman10310253busman
cabman123812503cabman
caiman103615663caiman
capelan1139003capelan
carman103920743carman
cateran9313773cateran
cavemen1437143cavemen
cayman133613213cayman
clean75420413cle_an
cowman13910373cowman
crewman1435753crewman
daemon9279593daemon
dalesman1145803dalesman
daman84821163_daman
daysman1335053daysman
dean56039483_de_an
deewan10267553deewan
demand104314253_demand
demean9510563_demean
demon86520313_demon
desman9311693desman
dewan95718043_dewan
dolman95312403dolman
edema8610553edema_
edemas9310503edemas
elan46734243__elan
enema7612743enema_
enemas8812003enemas
examen1538283examen
exempt1737453exempt
fireman1249333fireman
firman112211343firman
flyman14326423flyman
foemen11310523foemen
foreman12312363foreman
freeman1237343freeman
gagman103811243gagman
gamelan10106653gamelan
gamesman1344523gamesman
gasman92911743gasman
gatemen1047603gatemen
german9611983german
glean65818203gle_an
gleeman1035363gleeman
gunman9299453gunman
hackman1836433hackman
haemal113811643haemal
haemin113412663haemin
hangman1337813hangman
hanuman1237133hanuman
hemal104419803_hemal
hemin103620933_hemin
hetman112510603hetman
hiemal11339513hiemal
hitman112710223hitman
human102716033_human
icemen1037893icemen
jazzman2442553jazzman
jean116629283_je_an
landman1038923landman
lawman11289053lawman
layman113511303layman
lean46345243_le_an
legman949653legman
lemans85316393_lemans
lemon75618183_lemon
liman75921603_liman
lineman939123lineman
madman113712383madman
mailman1137733mailman
man57465873___man
maxima17568633maxima_
maximal18347093maximal
maximin1835263maximin
mean65538093_me_an
merman10513863merman
nema65522523_nema_
nemas75321573_nemas
nonman8412363nonman
oarsman937733oarsman
ocean71212963oce_an
oilman839483oilman
outman83115033outman
overman12311463overman
oxen116218593oxe__n
packman1736693packman
paean77222723pae_an
paesan85114093paesan
pean66147173_pe_an
pecan91919033_pecan
pekan111613973_pekan
penman10312323penman
pikeman1535523pikeman
pitman102412123pitman
placeman1445683placeman
potman102813573potman
premen105017803premen
quean143612843que_an
ragman94013713ragman
redan66125013_redan
reedman1037723reedman
remain85919863_remain
remand95618963_remand
remans84823003_remans
remap95418103_remap
reran57329103_reran
rewan85623663_rewan
rodman949713rodman
roman75424823_roman
sagaman10117563sagaman
salesman1047353salesman
sandman10310173sandman
seaman84015903seaman
sedan65620423_sedan
seedman1037373seedman
semen75724103_semen
sewan85921293_sewan
sextan13389643sextan
shaman113314283shaman
sideman1037973sideman
skean94415623ske_an
skyman1535313skyman
socman1039813socman
sokeman1337263sokeman
soman75024903_soman
spaceman1445323spaceman
spean74620513spe_an
talesman1046693talesman
taxeme1536253taxem_e
taxemes1635853taxemes
taxemic1835243taxemic
taximen1644923taximen
taxmen15367443tax_men
teleman959573teleman
tinman82411143tinman
titman82711003titman
toman75724053_toman
trepan82511673trepan
ulema7109713ulema_
ulemas888963ulemas
unman72715423_unman
vanman1139793vanman
vegan95114153_vegan
waterman1397283waterman
waxen154911813waxe__n
wean75734353_we_an
whaleman1643973whaleman
wireman1237843wireman
woman105818003_woman
xenon122612453_xenon
xylan1537463_xylan
yardman1335913yardman
yean75834583_ye_an
yeoman1138823yeoman

Search took 6 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 Limit1127162885.47020606.2
3Display Results2882880.0933096.8
 (SQL Overall)1786912885.93630102.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  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.