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

182 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
calamar114929(None) 
calamari1246121calamari
calamars1238131calamars
calamary1545461calamary
calamaris1346082calamaris
calamata1247552calamata
calami10313422calam_i
calamus1139242calamus
calcar10312752cal_car
calmer105216932cal_mer
clamor1049452c_lamor
jacamar1844322jacamar
palmar104113462pal_mar
patamar1147092patamar
agama85815583_agama_
agamas97413453_agamas
alamo7418143_alam_o
alamos8415003_alamos
alar46340073_al__ar
alcazar1843453_alcazar
alegar739283_alegar
alma66333023_al_ma_
almah106917253_al_mah
almas76629773_al_mas
almemar1144303_almemar
altar55520643_al_tar
alular6311353_alular
ataman81013063_ataman
avatar937523_avatar
balata8614673balata_
balatas9311833balatas
bazaar17306403baza_ar
blamer104417143_blamer
cabala103516913cabala_
cabalas113516003cabalas
cabana103913563cabana_
cabanas112413033cabanas
cabman123812503ca_bman
cadaver1335793cadaver
caeoma1039033caeoma_
caeomas1138403caeomas
caesar8410933ca_esar
caiman103615663ca_iman
calabash1544253calabash
calabaza2143463calabaza
calamanco1543113calamanco
calamander1553553calamander
calamaries1446873calamaries
calamatas1345783calamatas
calamine12314033calamine
calamint12315133calamint
calamite12312533calamite
calamity1547753calamity
calando1037383calando
calash11312433cala_sh
calathi1247583calathi
calcars11312653cal_cars
calcspar1442583calcspar
caldera1037963caldera
calendar1145013calendar
calesa8412473calesa_
calesas9411833calesas
caliber1139733caliber
caliper11410963caliper
calker124917083cal_ker
calla74827073cal_la_
callan83619603cal_lan
callas84526753cal_las
caller85125483cal_ler
calm85032363cal_m__
calmed114816383cal_med
calmly1337613cal_mly
calms95222353cal_m_s
calomel1138073calomel
caloyer1238143caloyer
calpac123211063cal_pac
caltrap11297943caltrap
calumet11313293calumet
calumny1443863calumny
calvary1537183cal_vary
camas96333523c__amas
canular9310323canular
carabao1139673carabao
caracal11312513caracal
caracara1247253caracara
caramba1336893caramba
caramel11310253caramel
carapax1835793carapax
caravan1239233caravan
caraway1538133caraway
carman103920743ca_rman
casaba1079263casaba_
casabas1139983casabas
casava1157873casava_
casavas1237823casavas
catamaran1344203catamaran
caveman1437073caveman
caviar11310163ca_viar
cayman133613213ca_yman
cellar84514983cel_lar
ceramal1138843ceramal
chadar1239353c_hadar
chalaza2145733chalaza_
chalazae2244423chalazae
chalazal2243873chalazal
chalazas2245893chalazas
chimar133911473c_himar
chlamys1733783chlamys
claimer11279883claimer
clam86332293c_lam__
clamant11312433c_lamant
clamber133311743c_lamber
clammer134211793clammer
clammy15356333c_lammy
clamors11710093c_lamors
clamour1196333c_lamour
clamp115517653c_lam_p
clamper134012993c_lamper
clamps124515083c_lamps
clams95127673c_lam_s
claver113816973c_laver
clawer114512783c_lawer
clear76219053c_l_ear
climax1735653c_limax
collar83816173col_lar
columnar1243713columnar
coplanar1244473coplanar
creamer113714093creamer
cymar125711263c__ymar
damar84117733__damar
dammar11438903da_mmar
flamer114919123_flamer
fulmar1137253ful_mar
glamor958183_glamor
halakah17517963halakah
halala94715093halala_
halalah13429393halalah
halalas104214083halalas
halavah16447023halavah
hallmark1744213hallmark
halma108219253hal_ma_
halmas117017893hal_mas
jacamars1944003jacamars
kalam11315113kalam__
kalamata1445273kalamata
kalams12310603kalam_s
lahar83114263__lahar
lama66635293__lama_
lamas75532793__lamas
lamer75233703__lamer
lazar144113643__lazar
llama799893_llama_
llamas888973_llamas
malar76424443mal__ar
pajama17317653pajama_
pajamas18278153pajamas
palabra1137183palabra
palapa10310673palapa_
palapas11311493palapas
palatal9310153palatal
palaver1238753palaver
palikar1335453palikar
palmary14338553pal_mary
palmer105816543pal_mer
panama104213353panama_
panamas113112763panamas
patamars1246843patamars
pattamar1243153pattamar
planar84212713_planar
sagaman10117563sagaman
salaam8711013sala_am
salaams997703salaams
salami8313103salam_i
salamis9313513salamis
scalar83612433scal__ar
scalawag14142773scalawag
talar56225383tal__ar
tarama8412733tarama_
taramas9612703taramas
ulama7711473_ulama_
ulamas8910453_ulamas
valvar12388653val_var

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271826.23321502.8
3Display Results1821820.0632888.9
 (SQL Overall)1786911826.70226662.3
 
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.