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

481 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
clinal831155(None) 
clonal8310911clonal
actinal9312292actinal
albinal937812albinal
binal75323822_binal
canal75428042c_anal
carinal94318232carinal
carnal83919202carnal
china105022482china_
chinas115119402chinas
chiral114614412chiral
chital114313882chital
cliental1045352cliental
climax1735652climax
clinally1347232clinally
clinch133910352clinch
cline76428532clin_e
clines84926042clines
cling86424672clin_g
clings95716212clings
clingy12659062clingy
clinic104312792clinic
clinical1247022clinical
clink115320042clin_k
clinks125815062clinks
coital84117052coital
final83922032_final
glial66715432gli_al
ilial55317842ili_al
lienal63912782_lienal
linac7315412_linac
lineal65616022_lineal
plical10411682plical
rhinal9510192rhinal
spinal84915312spinal
trinal6516962trinal
urinal6614122urinal
veinal93812962veinal
vinal85725812_vinal
achiral12109183achiral
acinar8310483acinar
aclinic11188973aclinic
affinal1336443affinal
agonal7410053agonal
alanyl955483alanyl
algal66518223al_gal
alias55834603ali_as
alidad838883alidad
aline57243153alin_e
alined75221403alined
aliner65621983aliner
alines65735223alines
aliya83713483aliya_
aliyah12397493aliyah
aliyas93911803aliyas
anal48037523__anal
anginal8310163anginal
animal85016253animal
annal56520763_annal
apical10913903apical
atonal6514023atonal
axial124515193axi_al
axonal1347653axonal
azonal1568273azonal
banal75925993_banal
basinal9310033basinal
blin67228173blin__
blind86319323blin_d
blindly1335743blindly
blinds95111613blinds
blini75519273blin_i
blinis85313683blinis
blink115720143blin_k
blinks124613573blinks
blintz1788843blintz
bridal9511453bridal
cabal95222153c_abal
caecal103713733caecal
caiman103615663caiman
cain65643913cain__
cains75334303cain_s
calendal1145383calendal
caliphal1544033caliphal
calycinal1652703calycinal
canals84421663c_anals
canna75919333canna_
cannas84518403cannas
cannel84216403cannel
cantal84122033cantal
capital112311523capital
cardinal1139563cardinal
carina84325323carina_
carinae94318583carinae
carinas93622403carinas
carpal103716253carpal
casual81112863casual
catnap1098383catnap
caudal91611483caudal
causal81413203causal
cecal94619113c_ecal
ceiba938703ceiba_
ceibas1038503ceibas
ceil65725063cei__l
celiac101910433celi_ac
cental84420963cental
cercal10314123cercal
cereal8315833cereal
chia96026623chi_a_
chiao105618363chi_ao
chias104625523chi_as
chica125818263chica_
chicas135916473chicas
chiel104918973chi_el
chill105619873chi_ll
chimar133911473chimar
chimla1337593chimla
chin96934743chin__
chinch163911233chinch
chine105231723chin_e
chined125620063chined
chines115029173chines
chink145321593chin_k
chinks155817573chinks
chinky185610543chinky
chino105823313chin_o
chinos115018693chinos
chins105631463chin_s
chints115117833chints
chintz204212033chintz
chinwag1643553chinwag
chisel112111943chisel
chloral12169983chloral
choral115118493choral
ciao64924183c_i_ao
cibol9512023c_ibol
cicala10310053c_icala
cicale10314503c_icale
cigar8911803c_igar
cilia73016763cilia_
cinch124516243c_inch
cine66242943c_in_e
cineol8108203c_ineol
cines75239683c_ines
citral81113893citral
civil103411933c_ivil
clad76225823cl__ad
clag75924573cl__ag
clam86332293cl__am
clan65633923cl__an
clang86019313clan_g
clangs95113613clangs
clank114719523clan_k
clanks124615183clanks
clanky15469073clanky
clans75031013clan_s
clap86429043cl__ap
clausal936273clausal
claw95624343cl__aw
clay95927413cl__ay
clean75420413cl_ean
cleanly1236323cleanly
cleans85817053cleans
clear76219053cl_ear
cleat76335063cl_eat
clench133910053clench
clerical1248233clerical
cliche133712453cliche
click135217953cli_ck
clicks145315113clicks
client8316343client
clients938093clients
cliff135917133cli_ff
cliffs14477593cliffs
cliffy17435243cliffy
clift106422193cli_ft
clifts11519153clifts
climatal1244403climatal
climate11312833climate
climb115413593cli_mb
climbs12498723climbs
clime95720893cli_me
climes104720003climes
clinged113310093clinged
clinger103812153clinger
clinics11338743clinics
clinked144011643clinked
clinker133811663clinker
clip86924003cli__p
clips96018303cli_ps
clipt96324273cli_pt
clique17289193clique
cliquy20324713cliquy
clitic103315053clitic
clitoral10106463clitoral
clivia1177233clivia
clivias1266693clivias
cloacal1135163cloacal
cloak115214013cl_oak
clon66232483clon__
clonally1346693clonally
clone75728163clon_e
cloned94518803cloned
cloner84418093cloner
clones84526563clones
clonic104914673clonic
clonk114417443clon_k
clonks125013473clonks
clons75228133clon_s
clonus85212413clonus
cluing93913503cluin_g
clung86013603clun_g
clunk114215083clun_k
clunks124811013clunks
clunky15447893clunky
clypeal1443513clypeal
cnida878953cnida_
cnidae978143cnidae
coal66939253c__oal
coaxal15387303coaxal
coccal9310223coccal
coeval1138893coeval
cognac1157273cognac
coil66439653coi__l
coin66645353coin__
coinable12311583coinable
coinage10310553coinage
coined94523603coined
coiner84323783coiner
coins75834553coin_s
colin76231693colin__
colinear1045913colinear
colins85229043colin_s
colonel94213283colonel
colonial10411343colonial
columnal1244413columnal
comal95125133c_omal
comical13312223comical
conical11316203conical
copal95621783c_opal
coral76033453c_oral
corneal94414503corneal
cornel84020053cornel
cornual94210173cornual
coronal94115763coronal
corral83616253corral
costal85419513costal
cotidal1038463cotidal
coxal146116673c_oxal
craal74117753c_raal
cranial92114683cranial
credal9311673credal
crenel84213063crenel
criminal1248303criminal
cringe93515483cringe
cringle103010353cringle
crinkle13359413crinkle
crinkly16387523crinkly
crinum1039333crinum
crissal937413crissal
crural8610633crural
cubical1338463cubical
cubital1137103cubital
cuing85420193cuin_g
culinary1355853culinary
cuneal8611513cuneal
curial84019153curial
curtal83914543curtal
cuspal1037883cuspal
cyclical1445653cyclical
cyclonal1544603cyclonal
cymbal15236913cymbal
cynical1437873cynical
denial74720513denial
dial55935063_di_al
dinar66319893_dinar
elint55436473elin_t
elints65816423elints
encinal949243encinal
epical10413393epical
faunal94711593faunal
filial93013253filial
finale94116763_finale
finals94316163_finals
finial92814183_finial
flinch144010103flinch
fling97023513flin_g
flings106715283flings
flint87333503flin_t
flints95617453flints
flinty126112493flinty
floral94313813floral
fluidal1144653fluidal
geminal10109903geminal
genial74917613genial
gingal81010153_gingal
glia56423153gli_a_
glias64618493gli_as
glint66830183glin_t
glints75714213glints
glinty106910693glinty
global937663global
helical12311153helical
hymnal1434913hymnal
ileal56118083il_eal
ilia46026823ili_a_
iliac75013493ili_ac
iliad64613463ili_ad
isoclinal1172663isoclinal
jingal1498593_jingal
kina85632003_kina_
kinas95626913_kinas
laical8312323laical
laminal94113633laminal
lanai5319573_lanai
leal46043273_l_eal
legal65715943_legal
liana53915893_liana
lianas63713383_lianas
liane54720663_liane
liang64914413_liang
liar47229683_li_ar
libel74116103_libel
lidar6312723_lidar
ligan67920283_ligan
lignan75510323_lignan
lilac7311073_lilac
lima65734133_lima_
liman75921603_liman
limas75627633_limas
liminal93810673liminal
lin37967373_lin__
linable92214343_linable
linacs8310813_linacs
linage7713403_linage
linalol745093_linalol
lindy96918313_lindy
line46965573_lin_e
linear65113343_linear
lined64934643_lined
linen55728723_linen
liner55938923_liner
lines57054573_lines
liney87029633_liney
ling57447963_lin_g
linga66820823_linga
lingam95112353_lingam
lingas75116573_lingas
lingo66022113_lingo
lings67135773_lings
lingual8379083_lingual
lingy96925143_lingy
linin58025523_linin
link86943443_lin_k
links96430193_links
linky127622383_linky
linn46034593_lin_n
linns56123333_linns
lino46343373_lin_o
linos55631503_linos
lins47059053_lin_s
lint416266233_lin_t
lintel64013993_lintel
lintol6369473_lintol
lints57137193_lints
linty87126563_linty
linum7313823_linum
liny78141323_lin_y
lipa68425923_lipa_
lira46928683_lira_
liras56021983_liras
litai55216363_litai
litas54923773_litas
local74820273_local
loral55927823_loral
loyal84513483_loyal
luminal93711003luminal
luna46229853_luna_
lunar57017313_lunar
lunas55025013_lunas
matinal9312603matinal
menial84223033menial
mina65136923_mina_
minae75627723_minae
minas75434113_minas
nidal65217103_nidal
nival84915773_nival
nominal92712373nominal
nounal639813nounal
ogival1035873ogival
olingo736933olingo
ordinal838633ordinal
paginal10269493paginal
penal75228373_penal
penial84120893penial
phial10313203phi_al
phonal11310383phonal
pial65636703_pi_al
pibal95217323_pibal
pical95524373_pical
pina65842633_pina_
pinas75434453_pinas
pineal84817683_pineal
pinnal84814273pinnal
pipal95118353_pipal
plagal948573plagal
planar84212713planar
plena75816393plena_
pleonal937243pleonal
plexal1536843plexal
pliant83918823pliant
plica9613373plica_
plicae10410953plicae
plink115219123plin_k
plinks124913263plinks
plinth11310453plinth
plural839823plural
primal104014623primal
quinol15357973quinol
quintal16389883quintal
reginal84814293reginal
regnal74812933regnal
renal55929503_renal
retinal75318353retinal
rial45938093_ri_al
rival85216503_rival
riyal84413433_riyal
ruminal9289993ruminal
salina64221123salina_
salinas73116093salinas
scleral937863scleral
scribal1137963scribal
seminal91213403seminal
sial45938833_si_al
signal73711483signal
sisal54217733_sisal
sling66028803slin_g
slings74618013slings
slink95422913slin_k
slinks104315153slinks
slinky13399103slinky
spinals93911863spinals
spinel85317333spinel
spiral83715343spiral
spital83813873spital
synclinal1443103synclinal
tarnal63716503tarnal
telial65815363teli_al
thenal92712423thenal
tical76021493_tical
tidal64516443_tidal
tincal83913363_tincal
tineal66216163_tineal
tonal53724303_tonal
trial54926353tri_al
tribal8611133tribal
ulna46317333ul_na_
ulnad65611453ul_nad
ulnae55214573ul_nae
ulnar56013983ul_nar
ulnas55716533ul_nas
uncinal959963uncinal
urial54823023uri_al
urinals7610253urinals
vaccinal1544903vaccinal
vaginal11288403vaginal
venal85523213_venal
venial94218283venial
vernal93514213vernal
vial76731093_vi_al
vicinal12268543vicinal
viminal12288823viminal
vina76331803_vina_
vinals94716483_vinals
vinas85126343_vinas
vineal94814743_vineal
vinyl115311623_vinyl
viral86419593_viral
vital84819673_vital
xenial133414903xenial
zonal145116853_zonal
zoonal1558083zoonal

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.376475242.0
2DLD Change Limit1127164814.90622975.1
3Display Results4814810.2162226.9
 (SQL Overall)1786914815.49832501.1
 
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.