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

365 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
addax143599(None) 
add510132362add__
addaxes1634572addaxes
added84918432added
adder75419592adder
addle74318352addle
adds67622452add_s
adman84517902adman
admix1557722admix
audad71511382audad
dada66422442dada_
dadas75819862dadas
handax1749582handax
aa219179953a__a_
aah616252963a__ah
aal39058673a__al
aas310975393a__as
aba512850953a_ba_
abas68642083a_bas
abba810522653abba_
abbas95918643abbas
abeam9316533abeam
acta69524803acta_
ad311975033a_d__
adage7414053adage
adapt81218553adapt
addable11218843addable
addend9458453addend
adders84315703adders
addict10711203addict
adding93914963adding
addled94112513addled
addles84216603addles
adduce1076453adduce
adduct1087373adduct
adeem8311803adeem
adept81219643adept
adieu6417423adieu
adieux1444283adieux
adios65822863adios
adit56443653a_dit
adits66523713adits
admass957143admass
admen84516183admen
admit8319493admit
admixt1637333admixt
adnate72913483adnate
adnexa1433673adnexa
ado49146873a_d_o
adobe84814703adobe
adobo84711593adobo
adopt81219743adopt
adore65723663adore
adorn64917093adorn
ados57633513a_dos
adown95611663adown
adoze155713833adoze
ads49755733a_d_s
adult63520653adult
adunc837433adunc
adust64117453adust
adyta936853adyta
adz1312332863a_d_z
adze1412820573a_dze
adzed166012543adzed
adzes155913803adzes
aedes64625143aedes
afar76720783a_far
affix1836003affix
aga410447233a_ga_
agar58726413a_gar
agas55938843a_gas
agha87417303agha_
aghas97014873aghas
agma77623263agma_
agmas85919873agmas
aha611246643a_ha_
ahead96817053ahead
aid49269073aid__
aide56044993aid_e
aided75828933aided
aider65431133aider
aides65336603aides
aidman92410623aidman
aids57846353aid_s
ajar116217703a_jar
ala312463603a_la_
alae45643753a_lae
alan46844083a_lan
alar46340073a_lar
alas46358123a_las
alba68328333alba_
albas75925393albas
alder65421913alder
aldol61212333aldol
alfa77624273alfa_
alfas87219043alfas
alga57927603alga_
algae65319623algae
algal66518213algal
algas65624933algas
alias55834603alias
alidad838873alidad
allay85620393allay
alma66333023alma_
almah106917253almah
almas76629773almas
altar55520643altar
alway116113923alway
ama510853303a_ma_
amah98927483a_mah
amas67746293a_mas
amia66836903amia_
amias75831473amias
ana39559823a_na_
anal48037523a_nal
anas46649863a_nas
and47244163and__
andro6314163andro
ands57833613and_s
anear55420323anear
anga56831353anga_
angas65827983angas
anlas55626933anlas
anna45529013anna_
annal56520763annal
annas55824883annas
annex12310883annex
anoa45634473anoa_
anoas57226493anoas
anodal72512113anodal
ansa45927773ansa_
ansae55720973ansae
anta46839583anta_
antae56828293antae
antas55432033antas
aoudad835033aoudad
apeak115513453apeak
apex137220213a_pex
apian75018333apian
apodal9289823apodal
appal95315223appal
aqua132813963aqua_
aquae142212713aquae
aquas142412613aquas
arak86929573a_rak
ardeb8314523ardeb
ardor64617863ardor
area45843393area_
areae55229743areae
areal55928733areal
areas55935773areas
argal65023383argal
arhat8327093arhat
aria46245423aria_
arias55438023arias
arras55626133arras
array86317143array
artal55525473artal
arval86017013arval
asdic83814093asdic
asea46327183asea_
assai5711543assai
assay8710283assay
atap66722453a_tap
ataxy1537313a_taxy
atlas55821583atlas
atma68121773atma_
atman75520143atman
atmas75721013atmas
attar56516693attar
audads8167103audads
audial7312993audial
audio62917103audio
audit62527883audit
aura45836253aura_
aurae54128113aurae
aural54428963aural
aurar54420253aurar
auras55932553auras
ava610139323a_va_
avgas96912133avgas
avian84616053avian
awa611939673a_wa_
away108024223a_way
ax911057783___ax
axal116520493a_xal
axial124515193axial
axman144813183axman
ayah108022993a_yah
azan136521783a_zan
badder103817513badder
baddie104114033baddie
baddy125016023badd_y
badman113813843badman
banda85223103banda_
bandas95120543bandas
banjax2234763banjax
borax145918723borax
caddie104316443caddie
caddis104613373caddis
caddy125414023cadd_y
caudad10157673caudad
caudal91611483caudal
caudex1636393caudex
cedar84014323cedar
coax136922973_coax
coda77029343coda_
codas84724243codas
codex155817573codex
dab67455563__dab
dad58456163__dad
daddle94214283daddle
daddy116212563daddy
dado67126333dad_o
dados75522433dados
dads67442773dad_s
daedal849083daedal
dag57753003__dag
dah78148983__dah
dak86340693__dak
dal47554953__dal
dam67457043__dam
daman84821163daman
damar84117733damar
dan46859663__dan
dap66652453__dap
data56026653data_
daw77148363__daw
day76254113__day
dead65434243_dead
deaf85838403_deaf
deal56347413_deal
dean56039483_dean
dear55343603_dear
dedal75719023dedal
dewax165510853dewax
dex116936883__dex
dhak125512033_dhak
dhal86719283_dhal
dial55935063_dial
doat56947673_doat
doux125817983_doux
drab76226453_drab
drag64825053_drag
dram75832003_dram
drat56247833_drat
draw85623013_draw
dray85428093_dray
duad66521413_duad
dual55928173_dual
dyad96415453_dyad
earwax1664733earwax
eddo63411803edd_o
eddy93912093edd_y
faddy135511623fadd_y
fax138143313__fax
fedex1699593fedex
flax147325633_flax
gadded103913173gadded
gadder93714713gadder
gaddi85211633gadd_i
gaddis94211373gaddis
galax135314463galax
garda7316763garda_
gardai839663gardai
gaydar1135503gaydar
giddap1143413giddap
goddam1145163goddam
hadal95518123hadal
hapax1739323hapax
hoax147718293_hoax
hodad10311353hodad
hyrax1838033hyrax
idea59122773idea_
ideal65716393ideal
ideas65919013ideas
index13310983index
judas134911883judas
keddah1534263keddah
khaddar1642113khaddar
ladder84617623ladder
laddie83713173laddie
landau7310613landau
lax107651523__lax
lidar6312723lidar
madam10316223madam
madcap1336333madcap
madded113513553madded
madden103912523madden
madder103515593madder
madman113712383madman
madras94316423madras
max129045443__max
mayday1535873mayday
medal86221323medal
midday13327503midday
modal85919233modal
nada58022903nada_
nadas66320813nadas
nidal65217103nidal
nodal64717793nodal
oda48133043_oda_
odah87018933_odah
odas57230263_odas
odd57725453odd__
odder74515393odder
oddly1037163oddly
odds68919923odd_s
odea56224573odea_
padded114113503padded
padder103415493padder
paddle104615143paddle
paddy125913593padd_y
padnag1036073padnag
panda85022613panda_
pandas95521963pandas
pardah123412823pardah
pax127346853__pax
paxwax1742953paxwax
payday1536613payday
pedal86022503pedal
radar61316723radar
radded94716493radded
raddle84816173raddle
radial74020393radial
radian74117273radian
radix134414593radix
randan7315253randan
rax108445723__rax
redan66125013redan
redox134714233redox
redux133811103redux
relax124817803relax
retax124517973retax
rewax155713923rewax
sadden83212403sadden
sadder82916973sadder
saddhu1133413saddhu
saddle83915493saddle
sandal73317283sandal
sanddab1144923sanddab
sardar73013173sardar
sax107447643__sax
sedan65620423sedan
soda56329383soda_
sodas64123543sodas
tax109449153__tax
tidal64516443tidal
today96416953today
udder76314283udder
vanda94515923vanda_
vandal103713833vandal
vandas103915993vandas
wadded124014173wadded
wadder114215483wadder
waddie114013323waddie
waddle114715303waddle
waddly14478723waddly
waddy135312993wadd_y
wadmal1237283wadmal
wax137041183__wax
woadwax2142163woadwax
zaddik2134243zaddik
zax197630633__zax

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 Filter178691836670.1261418182.5
2DLD Change Limit836673653.98321006.0
3Display Results3653650.0933924.7
 (SQL Overall)1786913654.20242525.2
 
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.