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

274 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
alcove117808(None) 
alcoved1375611alcoved
alcoves1297871alcoves
above105414322a_bove
alcade91111512alcade
aldose7311092aldose
alive85722512al_ive
allover1038582allover
aloe45540192al_o_e
alone55732962al_one
ancone83916952ancone
clove105619442cl_ove
cove95837072__cove
glove94516292gl_ove
love75234762_l_ove
talcose938132talcose
abode85518813a_bode
aboves114512843a_boves
absolve1244513absolve
accede1138303accede
accord1178843accord
accost101112263accost
accrue1035823accrue
accuse103411033accuse
ace59656833a_c__e
ache96829823a_c_he
ackee115825373a_ckee
acme86924323a_c_me
acne66625873a_c_ne
acnode938203acnode
acock132110213a_cock
acold86214933a_cold
acorn75616623a_corn
acre67330773a_c_re
active11313743active
acute74720363a_cute
adobe84814713a_dobe
adore65723673a_dore
adoze155713833a_doze
aerobe8412403aerobe
afore85818603a_fore
agave95314033a_gave
aglycone1442873aglycone
agone65924553a_gone
alae45643753al__ae
alamode1038153alamode
alane56135613al_ane
alate55340323al_ate
albacore1243523albacore
albicore1243703albicore
albite8313313albite
alcades101011473alcades
alcaic1039983alcaic
alcaide1088453alcaide
alcalde10104953alcalde
alcayde13103723alcayde
alcid85817973alc_id
alcids94812293alcids
alcohol1244363alcohol
aldol61212333aldo_l
aldols7109713aldols
aldoses8311203aldoses
ale36572343al___e
alee46652323al__ee
algae65319623al_gae
algoid83011473algoid
algor6513053algo_r
algors7312553algors
alible8311973alible
alike95523963al_ike
aline57243153al_ine
alkane104313323alkane
alkene104114003alkene
alkie95520033al_kie
alkine104916803alkine
alkoxy2033343alkoxy
alkyne13436863alkyne
allee54932123al_lee
allege74314653allege
allele64514563allele
allod64418383allo_d
allods73615083allods
allonge837023allonge
allot54933873allo_t
allots64019173allots
allovers1137673allovers
allow85420663allo_w
allowed111610083allowed
allows94517683allows
alloy85519973allo_y
alloyed11158033alloyed
alloys94014563alloys
allude73910903allude
allure63012943allure
alme65832163al__me
almond91410433almond
almoner949383almoner
almost81014433almost
almuce10348213almuce
almude9399933almude
aloes54933673al_oes
aloft8423433al_oft
aloha8513613al_oha
aloin55227423al_oin
along65419493al_ong
aloof83521573al_oof
aloud65018073al_oud
alow75328593al_o_w
alpine84417373alpine
alsike1047913alsike
also46423443also__
alto47831263alto__
altos55822953alto_s
alulae6312743alulae
alvine94614583alvine
amole75724593a_mole
anchovy1843953anchovy
ancon75718233anco_n
ancones93116343ancones
anode65021043a_node
anole55330383a_nole
anyone94612733anyone
apocope1346033apocope
appose10411993appose
approve14116603approve
arcade91013643arcade
arcane81216743arcane
archive154610483archive
arco68331543arco__
areole61017283areole
ariose64818723ariose
arkose104911343arkose
arose55832083a_rose
arrive91311793arrive
ascot76522513asco_t
ascots85312513ascots
ashore9414613ashore
aslope839013aslope
atone56527983a_tone
ave67748703a___ve
awoke124912003a_woke
axone125918473a_xone
azole145118033a_zole
azote144416343a_zote
balcony1435853balcony
become123312593become
behove14207203behove
bloke114316633bl_oke
blooie83913193blooie
calcine11315273calcine
calcite11413783calcite
callose9313663callose
calve105919923cal__ve
calzone1848623calzone
cave95941263__cave
clave105420153cl_ave
cleave114212513cleave
cleome1039083cleome
cloche134312373cloche
clone75728163cl_one
close76425223cl_ose
cloven114211513cl_oven
clover114617123cl_over
cloves114918823cl_oves
cloze165517543cl_oze
code77347733__code
coke107038383__coke
cole66956113__cole
come87547703__come
cone67256963__cone
cope86847383__cope
core67263113__core
cote66648733__cote
coved115027373__coved
coven106925043__coven
cover105430773__cover
coves105539173__coves
covet105638943__covet
covey136121783__covey
decode104414743decode
dove85131563__dove
drove95518063_drove
elope75219343el_ope
encode9310443encode
encore8314773encore
falcate12311613falcate
falcon11310293falco_n
falconer1346033falconer
falconet13410353falconet
falcons1239123falcons
floe76129773fl_o_e
flooie93712153flooie
flyover1633513flyover
fucose11167683fucose
galore73514853gal_ore
glaive10357933glaive
globe84917013gl_obe
gloved114811873gl_oved
glover104513533gl_over
gloves104115183gl_oves
gloze154815983gl_oze
glucose1045113glucose
groove10438873groove
grove95219333_grove
halve114818923hal__ve
hove107132223__hove
income10712093income
inwove12167273inwove
jocose1537103jocose
lace66848473lac__e
lactone9311393lactone
lactose969473lactose
lacune8169673lacune
lanose6313593lanose
lave75642143_l_ave
layover1334433layover
leave84723723_leave
leone55018823_leone
lieve86315473_lieve
live76540993_l_ive
lobe65535363_l_obe
lode56240113_l_ode
loge56837193_l_oge
lone45849133_l_one
looie55624243_looie
loose56627683_loose
lope65941923_l_ope
lore45850353_l_ore
lose45144583_l_ose
loved95021363_l_oved
lover85526453_l_over
loves85332013_l_oves
lowe75435313_l_owe
maltose939783maltose
move96630723__move
mucose10149313mucose
narcose95910383narcose
olive84817153ol_ive
plover115312613pl_over
poove104514303_poove
prove104823193_prove
recode93618713recode
recover124312623recover
remove116115573remove
rewove126420073rewove
rove75136983__rove
salve85022133sal__ve
scone74621833_scone
scope94821483_scope
score75526733_score
shove114421043_shove
shrove125412233shrove
slave84224033sl_ave
sleave94714153sleave
sleeve93411593sleeve
slieve9359273slieve
sloe45534953sl_o_e
slope75823563sl_ope
sloven9389633sl_oven
stove85220253_stove
strove95014793strove
talcous939483talcous
throve128012393throve
trove85221923_trove
uncover1239003uncover
unrove92511683unrove
unwove12238883unwove
updove1234483updove
uphove1436133uphove
valve114515933val__ve
walkover1842943walkover
welcome1445193welcome
wove105624313__wove
zlote143912943zl_ote

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.1231452772.4
2DLD Change Limit1127162745.61020092.0
3Display Results2742740.0803425.0
 (SQL Overall)1786912745.81330739.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.