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

191 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
alpaca104738(None) 
alpacas1137071alpacas
abaca95118042a_baca
alack114820062al_ack
albata839332albata
alpha1049652alp_ha
apace94718382a_pace
calpac123211062calpac_
calpack17338332calpack
calpacs133110342calpacs
cloaca1037262cloaca
kalpac14428222kalpac_
kalpacs15327132kalpacs
paca85132242__paca
abacas104414723a_bacas
abaci94718843a_baci
aback134816173a_back
abaka114313823a_baka
abaya104413173a_baya
abbacy1536623abbacy
acacia10311353a_cacia
agama85815583a_gama
aggada955223aggada
ala312463603al___a
alae45643753al_a_e
alamo7418143al_amo
alan46844083al_a_n
aland65526413al_and
alane56135613al_ane
alang66023513al_ang
alans55636173al_ans
alant55742293al_ant
alar46340073al_a_r
alarm76621423al_arm
alary86123443al_ary
alas46358123al_a_s
alaska1036713alaska
alate55340333al_ate
alba68328333al__ba
albas75925393alba_s
albatas938373albatas
alcade91111513alcade
alcaic1039983alcaic
alcaics1137023alcaics
alcazar1843453alcazar
alec66430063al_ec_
alecs76620733al_ecs
alexia132910463alexia
alfa77624273al__fa
alfaki1385383alfaki
alfalfa1342443alfalfa
alfas87219043alfa_s
alga57927603al__ga
algae65319623alga_e
algal66518223alga_l
algas65624933alga_s
alias55834603alia_s
aliya83713483al_iya
alkali10127563alkali
alkane104313323alkane
allay85620393alla_y
allays94313743allays
alma66333023al__ma
almah106917253alma_h
almahs118611613almahs
almanac1156033almanac
almas76629773alma_s
almuce10348213almuce
alnico877943alnico
alodia71112453alodia
aloha8513623al_oha
alopecia1244433alopecia
alp56641133alp___
alphas1139513alphas
alphyl1484083alphyl
alpine84417373alpine
alps65529243alp__s
altar55520643alta_r
altars64518153altars
althaea1044363althaea
althea938213althea
alula5317093al_ula
alumna857343alumna
alway116113923alwa_y
always12409133always
anlace82513923anlace
apache134210783a_pache
apart74330673a_part
apical10913903a_pical
aplasia92510803aplasia
apnea73413413a_pnea
appal95315223appa_l
appall10379743appall
appals104812943appals
apparat11711713apparat
arcana8912583arcana
areca75618633a_reca
argala74712673argala
armada938783armada
arnica8310443arnica
arrack121110253arrack
asana5315483a_sana
aspect10612823aspect
aspic95114733aspic_
aspics104211563aspics
asrama839193asrama
attach11118393attach
attack12148153attack
balata8614683bal_ata
bipack1636523bipack
black134719073bl_ack
bleach133611403bleach
caca85528083__caca
calpacks18266523calpacks
calpain11310413calpain
champaca1943203champaca
clach124617823cl_ach
clack134720173cl_ack
cloacae1145233cloacae
cloacal1135163cloacal
cloacas1136233cloacas
epact94921533_epact
falbala1235873falbala
fallacy1536433fallacy
flack144519413fl_ack
gallica1047463gallica
galyac1235973galyac_
galyacs1335273galyacs
glace87420163gl_ace
halacha15388023hal_acha
halala94715093hal_ala
ileac75814173ileac_
iliac75013493iliac_
impact122310453impact
impala10256933impala
kalpa114512193kalp__a
kalpak11437243kalpa_k
kalpaks12366163kalpaks
kalpas124112943kalpa_s
labara83712893labara
lac510155823_l_ac_
lace66848473_l_ace
lack105837683_l_ack
lacs66942483_l_acs
lacy95829633_l_acy
lama66635293_l_ama
lava76725423_l_ava
leach105422523_leach
liana53915893_liana
llama799893_llama
loach105116363_loach
loca65527683_l_oca
malacca1344963malacca
manpack1746063manpack
maraca10314153maraca
pac79054083__pac_
pacas96029403__pacas
pace86345773__pace
pacha126518063__pacha
pack125535443__pack
pacs85842183__pacs
pact86648723__pact
pacy115328683__pacy
palace104516923pal_ace
palapa10310673pal_apa
palpal104112053palpa_l
palpate113213923palpate
papa85827143__papa
papacy1547493papacy
papaya1337503papaya
para65242173__para
pataca10311193pataca
pica85831493__pica
place94824613pl_ace
plack135017843pl_ack
playa105812943pl_aya
plaza164311063pl_aza
pleach134211243pleach
plica9613373pl_ica
repack142412163repack
salpa75018353salp__a
salpae84614273salpa_e
salpas85116923salpa_s
slack115021763sl_ack
space95325673_space
spacy125415623_spacy
spica94717943_spica
tampala1136613tampala
ulama7711473ul_ama
ulpan7310123ulpa_n
unpack1457833unpack

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.390458182.1
2DLD Change Limit1127161916.09618490.2
3Display Results1911910.0464152.2
 (SQL Overall)1786911916.53227356.2
 
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.