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

513 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
lallan6341417(None) 
callan83619601callan
lalland83810171lalland
lallans74113531lallans
alan46844082_a_lan
allay85620392_allay
ballad94315322ballad
ballon84117492ballon
calla74827072calla_
callans94518472callans
callant94121222callant
callas84526752callas
fallal93612692fallal
fallen93813372fallen
gallant83517112gallant
gallon73715812gallon
hallah124115402hallah
hallal94415562hallal
kalian10312162kalian
lagan66520342la_gan
lall45531312lall__
lallands9338562lallands
lalled74218752lalled
lalling83519622lalling
lalls55324132lall_s
lauan55216792la_uan
lawman11289052lawman
layman113511302layman
raglan73711502raglan
walla85321032walla_
wallah124011992wallah
wallas95719392wallas
adman84517903_adman
ala312463603_a_la_
alae45643753_a_lae
aland65526413_a_land
alane56135613_a_lane
alang66023513_a_lang
alans55636173_a_lans
alant55742293_a_lant
alar46340073_a_lar
alas46358123_a_las
alba68328333_alba_
albas75925393_albas
alfa77624273_alfa_
alfas87219043_alfas
alga57927603_alga_
algae65319623_algae
algal66518223_algal
algas65624933_algas
algin65718763_algin
alias55834603_alias
alien56425583_alien
align65016503_align
alkane104313323_alkane
all36148233_all__
allays94313743_allays
allee54932123_allee
alley85721673_alley
allod64418383_allod
allot54933873_allot
allow85420663_allow
alloxan1445773alloxan
alloy85519973_alloy
alls46740923_all_s
ally76935643_all_y
allyl85310543_allyl
alma66333023_alma_
almah106917253_almah
almas76629773_almas
aloin55227423_aloin
altar55520643_altar
alula5317093alula_
alulae6312743alulae
alular6311353alular
alway116113923_alway
anlas55626933_anlas
apian75018333_apian
aslant6317753_aslant
atlas55821583_atlas
atman75520143_atman
avellan1037293avellan
avian84616053_avian
axman144813183_axman
azan136521783_a_zan
azlon144312873_azlon
badland1147653badland
badman113813843badman
bagman114613813bagman
balas76937213ba_las
baleen8613053baleen
ball66043323ball__
ballade104012563ballade
ballads104212913ballads
ballast9313993ballast
balled94926893balled
baller83825203baller
ballet84733973ballet
balling104424763balling
ballons93916963ballons
balloon93711433balloon
ballot84624093ballot
balls76236413ball_s
ballsy11508873ballsy
bally105530103ball_y
balsa77920413balsa_
balsam105612233balsam
balsas86417523balsas
banian8315383banian
banyan1139483banyan
barman103519703barman
batman105214063batman
bayman133712703bayman
bellman1137183bellman
billon83713833billon
bulla74620563bulla_
bullae83416163bullae
cabman123812503cabman
caftan111710123caftan
caiman103615663caiman
calcar10312753calcar
calkin123515493calkin
call66838673call__
callants104112143callants
called94126733called
callee84327293callee
caller85125483caller
callet84536763callet
calling103826773calling
callow114714663callow
calls75634733call_s
callus85317073callus
calpac123211063calpac
calpain11310413calpain
cancan10314103cancan
capelan1139003capelan
caplin103216303caplin
captan101613343captan
carlin84421823carlin
carman103920743carman
catlin83819083catlin
cayman133613213cayman
cella75420313cella_
cellae84915933cellae
cellar84514983cellar
challa114014193challa_
challah15458323challah
challas124414123challas
clachan1437183clachan
clan65633923__clan
claypan1434313claypan
clean75420413_clean
collar83816173collar
cullay113910173cullay
dalles74222063dalles
dally95324743dall_y
dalton7311273dalton
daman84821163da_man
dollar74110983dollar
dolman95312403dolman
earlap837183earlap
elan46734243__elan
eolian6312593eolian
falcon11310293falcon
fall75535313fall__
fallacy1536433fallacy
fallals103310193fallals
faller94621233faller
falling113621583falling
fallow124713853fallow
falls85727653fall_s
fella84918653fella_
fellah124910773fellah
fellas95116963fellas
flagman13186173flagman
flan76134183__flan
flatland1264963flatland
fullam1138363fullam
gagman103811243gagman
gala55635163ga_la_
galah95917633ga_lah
galas65731643ga_las
galax135314463ga_lax
galea64722933galea_
galeae74717453galeae
galeas74618513galeas
galena74911093galena
gall56335993gall__
gallants93310373gallants
gallate83417123gallate
galled84622863galled
gallein8299043gallein
galleon8278713galleon
gallet73630853gallet
galley104215453galley
gallic9411643gallic
gallican1155333gallican
galling93921963galling
gallons83015953gallons
galloon82910643galloon
gallop93311383gallop
galls64729323gall_s
gallus74313203gallus
gally95026173gall_y
galyac1235973galyac
galyak1445333galyak
gamelan10106643gamelan
garland948703garland
gasman92911743gasman
gellant83214053gellant
glean65818203_glean
halal85623593ha_lal
halala94715093halala
halalah13429393halalah
halalas104214083halalas
halals95018313halals
hall75741163hall__
hallahs133912463hallahs
hallel93514093hallel
hallo85127553hall_o
halloa94918123halloa
halloas104318463halloas
halloo95118973halloo
hallos95425103hallos
hallot95426783hallot
hallow124818323hallow
halls85633783hall_s
hallux1637363hallux
hallway1636173hallway
halma108219253halma_
halmas117017893halmas
halon86124863ha_lon
halva115414433halva_
halvah15499833halvah
halvas124714173halvas
hazan173813613ha_zan
hazzan17236803hazzan
holla84918493holla_
holland11349473holland
hollas94616903hollas
jalap143612473ja_lap
japan14411233ja_pan
jawan15710383ja_wan
kaftan13185823kaftan
kalam11315113ka_lam
kalians11310183kalians
kalpa114512193kalpa_
kalpac14428223kalpac
kalpak11437243kalpak
kalpas124112943kalpas
kanban1238623kanban
kaolin1039583kaolin
labella988943labella_
labia75219013labia_
labial84714343labial
labra75415463labra_
lactam10310943lactam
lactean956473lactean
lacuna8118123lacuna
laden65022193la_den
ladle66320443ladl_e
ladled85013483ladled
ladler74314933ladler
ladles74619543ladles
ladling92813393ladling
ladron73413323ladron
lagans75717783la_gans
lagoon7410483lagoon
laguna7127223laguna
lahar83114263la_har
laical8312323laical
lain46146283la__in
lallation939493lallation
lallygag1341903lallygag
lama66635293la_ma_
lamas75532793la_mas
lamella988613lamella_
lamellae10117033lamellae
lamellar1096493lamellar
lamellas1098163lamellas
lamia75324323lamia_
lamiae84817453lamiae
lamias85020613lamias
lamina84920443lamina
lampad114510033lampad
lampas106615953lampas
lanai5319573la_nai
landau7310613landau
landman1038923landman
lanolin7310643lanolin
lantana739603lantana
laogai735983laogai
lapin75222923la_pin
lardon74415063lardon
lariat6629043lariat
larva8312483larva_
larvae938843larvae
larval948503larval
larvas9310233larvas
lascar868573lascar
lateen64014863lateen
laten54328343la_ten
latilla737953latilla_
latillas847363latillas
latina65621143latina
latten65018203latten
lattin64316223lattin
lauans65113533la_uans
laura54116203laura_
laurae64011663laurae
lauras63414333lauras
lava76725423la_va_
lavas85422223la_vas
lawmen11308593lawmen
lawn75925633la__wn
laxly15610103laxl_y
layin84720333la_yin
laymen113010843laymen
lazar144113643la_zar
leadman10237843leadman
leally94012613leall_y
lean46345243__lean
legman949653legman
leman75622603l_eman
liblab1035083liblab
ligan67920283l_igan
lignan75510323lignan
lilac7311073l_ilac
liman75921603l_iman
llama799893llama_
llamas888973llamas
llano5910603__llano
loan47436453__loan
lochan1139093lochan
logan68123283l_ogan
loll46128383loll__
lolled74315823lolled
loller63315283loller
lolling83415773lolling
lollop8238783lollop
lolls512121733loll_s
lolly85120663loll_y
longan75612363longan
loran55925093l_oran
lowland1134693lowland
lull44225763lull__
lullaby1243363lullaby
lulled74516443lulled
luller63415483luller
lulling83616803lulling
lulls54119653lull_s
lungan74710213lungan
lurdan738363lurdan
madman113712383madman
magian9312833magian
mailman1137733mailman
malar76424443ma_lar
malign939853malign
malkin122913153malkin
mall64639373mall__
mallard10310273mallard
malled94626113malled
mallee84525593mallee
mallei84414633mallei
mallet84433053mallet
malling103623663malling
mallow114014743mallow
malls76233433mall_s
mannan85413623mannan
marlin84220903marlin
mayan105616903ma_yan
mollah11319453mollah
mulla74317113mulla_
mullah113710733mullah
mullas84215933mullas
mullen83714763mullen
naan47621933na__an
nala46930393na_la_
nalas55528363na_las
nullah9388143nullah
oilcan837793oilcan
oilman839483oilman
olla44821173_olla_
ollas54218283_ollas
paean77222723pa_ean
paella8410913paella_
paellas9411413paellas
paesan85114093paesan
pagan86121163pa_gan
paisan84417073paisan
palea75028663palea_
paleae84820293paleae
paleal84716673paleal
pall65039343pall__
palled94625163palled
pallet84232653pallet
pallia83015593pallia
pallial92911253pallial
pallid93915283pallid
palling104024483palling
pallor8313673pallor
palls74332563pall_s
pally105727123pall_y
palmar104113463palmar
palpal104112053palpal
parian83223963parian
parlay113713993parlay
partan83820563partan
paulin8312983paulin
pavan106518473pa_van
pillar8314023pillar
plan65833943__plan
platan83913693pla_tan
playland1444573playland
pollen83416453pollen
prolan8414693prolan
pullman1135403pullman
radian74117273radian
raglans82410133raglans
ragman94013713ragman
ralline73518413ralline
rally84725903rall_y
rallye95110163rallye
randan7315253randan
ratan53722663ra_tan
ratlin64116523ratlin
rattan63613603rattan
reloan6415693reloan
replan83215823replan
salaam8711013salaam
salad65321833sa_lad
salal55425703sa_lal
salals65120083salals
salina64221123salina
sall44544683sall__
sallet63734543sallet
sallow94315753sallow
sally85129713sall_y
salmon84614183salmon
salon55228553sa_lon
saloon64418023saloon
salpa75018353salpa_
salpae84614273salpae
salpas85116923salpas
salpian938493salpian
salsa56718923salsa_
salsas65316133salsas
saltant7316773saltant
saltpan935303saltpan
sampan102511893sampan
saran53730303sa_ran
silvan92810153silvan
solan55328153_solan
soldan73511853soldan
suldan72611043suldan
sullen62914293sullen
sultan63012593sultan
sylvan12257363sylvan
tabla73318363tabla_
tablas83716163tablas
tailfan1044653tailfan
taipan82410663taipan
tala45938053ta_la_
talar56225383ta_lar
talas55935893ta_las
talion6317713talion
tall47240213tall__
tallage82712073tallage
taller63721963taller
tallis63319963tallis
tallit63422733tallit
tallol63612223tallol
tallow93714203tallow
talls55133433tall_s
tally84526863tall_y
tallyman1344213tallyman
talon55824113ta_lon
tampan102512323tampan
tarpan82814293tarpan
tartan64217513tartan
tarzan152910753tarzan
taxman15328613taxman
tolan55124013_tolan
tollman935863tollman
uhlan849113_uhlan
ulan46527393__ulan
ulpan7310123_ulpan
valiant10314623valiant
vallate103016563vallate
valley124311603valley
valval12398863valval
valvar12388653valvar
vanman1139793vanman
villa85321233villa_
villae95615383villae
villain1038473villain
villas96117263villas
wall76236103wall__
wallaby1535073wallaby
wallahs13409473wallahs
walled104021293walled
wallet93327093wallet
wallie93216803wallie
walling113520973walling
wallop113310293wallop
wallow123913513wallow
walls85529383wall_s
wally114625093wall_y
wangan10311223wangan
waylay1535453waylay
xylan1537463_xylan
yulan8411493_yulan
zillah1836563zillah

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.1401276364.3
2DLD Change Limit1127165135.34321096.0
3Display Results5135130.1703017.6
 (SQL Overall)1786915135.65331609.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.