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

224 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
kalpac1442822(None) 
calpac123211061calpac
kalpa114512191kalpa_
kalpacs15327131kalpacs
kalpak11437241kalpak
kalpas124112941kalpas
alpaca1047382_alpaca
calpack17338332calpack
calpacs133110342calpacs
galyac1235972galyac
kalam11315112kal_am
kalian10312162kalian
kalpaks12366162kalpaks
kapa106021292ka_pa_
kapas116021732ka_pas
kappa13469742kappa_
kappas144410362kappas
palpal104112052palpal
salpa75018352salpa_
salpae84614272salpae
salpas85116922salpas
ala312463603_al_a_
alack114820063_al_ack
alae45643753_al_ae
alan46844083_al_an
alar46340073_al_ar
alas46358123_al_as
alba68328333_alba_
albas75925393_albas
alcaic1039983_alcaic
alec66430063_al_ec
alfa77624273_alfa_
alfas87219043_alfas
alga57927603_alga_
algae65319623_algae
algal66518223_algal
algas65624933_algas
alias55834603_alias
allay85620393_allay
alma66333023_alma_
almah106917253_almah
almas76629773_almas
alp56641133_alp__
alpacas1137073_alpacas
alpha1049653_alpha
alphas1139513_alphas
alps65529243_alp_s
altar55520643_altar
alway116113923_alway
apace94718383_a_pace
appal95315223_appal
aspic95114733_aspic
balas76937213bal_as
ballad94315323ballad
balsa77920413balsa_
balsam105612233balsam
balsas86417523balsas
calcar10312753calcar
calcic9311873calcic
calla74827073calla_
callan83619603callan
callas84526753callas
calpacks18266523calpacks
calpain11310413calpain
carpal103716253carpal
celiac101910433celiac
champac1834953champac
culpa93610963culpa_
culpae10389263culpae
fallacy1536433fallacy
fallal93612693fallal
gala55635163gal_a_
galah95917633gal_ah
galas65731643gal_as
galax135314463gal_ax
galea64722933galea_
galeae74717453galeae
galeas74618513galeas
gallic9411643gallic
galyacs1335273galyacs
galyak1445333galyak
halal85623593hal_al
hallah124115403hallah
hallal94415563hallal
halma108219253halma_
halmas117017893halmas
halva115414433halva_
halvah15499833halvah
halvas124714173halvas
hapax1739323ha_pax
heliac111010893heliac
ileac75814173_ileac
iliac75013493_iliac
jalap143612473jal_ap
jalapic1844543jalapic
jalaps15299183jalaps
japan14411233ja_pan
kaas86531843ka__as
kabab134814443ka_bab
kabar114815553ka_bar
kaftan13185823kaftan
kaiak8310353ka_iak
kaka76518683ka_ka_
kakapo1143853kakapo
kakas85117343ka_kas
kalams12310603kalams
kale86533753kal__e
kales95730983kal_es
kalians11310183kalians
kalif125021363kal_if
kalifs134410983kalifs
kaliph1537873kaliph
kaliphs1634293kaliphs
kalium1239473kalium
kalmia1238893kalmia
kalmias1347973kalmias
kalong1177703kalong
kana85928533ka_na_
kanas95326913ka_nas
kanban1238623kanban
kantar10311153kantar
kaonic1238763kaonic
kaph135815753ka_p_h
kaphs144911503ka_phs
kapok10448783ka_pok
kaput11717063ka_put
karat96837593ka_rat
karma113415003karma_
karmas123013733karmas
karmic1438113karmic
kasbah1535183kasbah
kasha124710723kasha_
kashas133311903kashas
kata85626023ka_ta_
katas95922093ka_tas
kava115819703ka_va_
kavas125919953ka_vas
kayak1138363ka_yak
kelp105322803kelp__
kelped13449543kelped
kelpie12308613kelpie
kelps115116423kelp_s
kelpy145110683kelp_y
keypad1633823keypad
keypal1534893keypal
koala95112213koal_a_
koalas104011663koal_as
kola85124963kol_a_
kolas94822233kol_as
koppa13397293koppa_
koppas14407603koppas
kulak858823kul_ak
lac510155823__l_ac
lallan63414173lallan
lampad114510033lampad
lampas106615953lampas
lilac7311073lil_ac
malar76424443mal_ar
malic94525663mal_ic
maniac103917973maniac
manpack1746063manpack
milpa92111403milpa_
milpas101710273milpas
nala46930393nal_a_
nalas55528363nal_as
napa66927263na_pa_
napas75924353na_pas
nappa98511863nappa_
nappas105511613nappas
pac79054083___pac
palace104516913pal_ace
palapa10310673palapa
palapas11311493palapas
palea75028663palea_
paleae84820293paleae
paleal84716673paleal
palmar104113463palmar
palp85828573palp__
palpate113213923palpate
palped114513643palped
palpi95414553palp_i
palps94719563palp_s
palpus104210283palpus
pampa114913423pampa_
pampas124913993pampas
papa85827143pa_pa_
papacy1547493pa_pacy
papal95820673pa_pal
papas94927493pa_pas
papaw125112493pa_paw
pawpaw1653503pawpaw
pulpal10408453pulpal
ralph1078743ralp_h
ralphs1135373ralphs
salaam8711013salaam
salad65321833sal_ad
salal55425703sal_al
salic73424713sal_ic
salp64534093salp__
salpian938493salpian
salpid9510883salpid
salps74423243salp_s
salsa56718923salsa_
salsas65316133salsas
saltpan935303saltpan
sampan102511893sampan
skaldic1443553skaldic
taipan82410663taipan
tala45938053tal_a_
talar56225383tal_ar
talas55935893tal_as
talc66226813tal__c
tambac122210243tambac
tampan102512323tampan
tapa65129143ta_pa_
tapas74627713ta_pas
tarmac10310333tarmac
tarpan82814293tarpan
ulpan7310123_ulpan
valval12398863valval
valvar12388653valvar
walla85321033walla_
wallah124011993wallah
wallas95719393wallas

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.1431249587.4
2DLD Change Limit1127162245.93618988.5
3Display Results2242240.0762947.4
 (SQL Overall)1786912246.15529031.8
 
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.