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

279 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
cranial9211468(None) 
crania82418431crania_
canal75428042c_an_al
cantal84122032c_antal
carinal94318222carinal
carnal83919202carn_al
carnival1345612carnival
coaxial16157002coaxial
craal74117752cra__al
cranially1447892cranially
craniate10312562craniate
craning103620302craning
cranium11911102cranium
crucial1157892crucial
geranial949282geranial
prandial1149642prandial
racial83419242_racial
radial74020392_radial
urania62516122urania_
uranias72113812uranias
abaxial1646183abaxial
achenial1348283achenial
acrasia9310033acrasia_
acrasias1048893acrasias
acromial1248463acromial
acronical1347833acronical
adagial946363adagial
adaxial1545323adaxial
anal48037523__an_al
anil46437433__ani_l
animal85016253__animal
annal56520763__annal
axial124515193__axial
banal75925993_ban_al
banian8315383_banian
baronial1049483baronial
biaxial1645363biaxial
biracial12107973biracial
biradial1167713biradial
brachial15219303brachial
brail75525553bra_i_l
brainiac1245633brainiac
branchial16215953branchial
brantail1046893brantail
brasil8713863brasi_l
brazil1779623brazi_l
cabal95222153c_a_bal
caecal103713733c_aecal
camail10314823c_amail
cambial134010763cambial
canals84421663c_an_als
cancan10314103c_ancan
cancel105316683c_ancel
candidal12367733c_andidal
canful11610263c_anful
canid85526343c_ani_d
canids95118133c_anids
canine83826703c_anine
caning94128623c_aning
canna75919333c_anna_
cannas84518403c_annas
cannel84216403c_annel
cannibal1245203cannibal
canola8313623c_anola
cantala94114673c_antala
cantals93919573c_antals
canthal12410053c_anthal
canula8312963c_anula
canvas113813333c_anvas
capias10318353c_apias
capital112311523c_apital
caracal11312513caracal
cardia9916373cardia_
cardiac1278813cardiac
cardiae10713703cardiae
cardias10715093cardias
cardinal1139553cardinal
carina84325323carina_
carinae94318583carinae
carinas93622383carinas
carnie84421093carni_e
carnies94123963carnies
carnify1555883carnify
carnivals1444483carnivals
carpal103716253c_arpal
casual81112863c_asual
caudal91611483c_audal
causal81413203c_ausal
caviar11310163c_aviar
cavil103816493c_avi_l
cental84420963c_ental
ceramal1138843cera_mal
cercarial1346023cercarial
chaetal1238283chaetal
chancel144011773chancel
channel123910483channel
chasmal14158213chasmal
chorial124214143chorial
clausal936273clausal
clinal8311553clin_al
clinical1247023clinical
clonal8310913clon_al
coaeval1245183coaeval
coastal9411033coastal
coaxal15387303coa_xal
colonial10411343colonial
conical11316203c_onical
cordial10312933cordial
corneal94414503corneal
cornual94210173cornual
coronal94115763coron_al
craals84113303cra__als
cranch133613533cran_ch
crane75331603cran__e
craned96121653cran_ed
cranes84330753cran_es
craniates11310653craniates
craniums1297913craniums
crank114819613cran__k
cranked143812843cranked
cranker133612783cranker
crankier14339163crankier
crankily1755623crankily
cranking154613073cranking
crankish1736513crankish
crankle133610063crankle
crankly16358123crankly
cranks125015313cran_ks
cranky153910633cran_ky
crannied1137893crannied
crannies10313013crannies
crannog1044243crannog
cranny114210273cran_ny
craping124018713craping
crapola1136913crapola
crasis85020473crasi_s
crating103725203crating
cravat11314443cra_vat
craving134015733craving
crawdad1443113crawdad
crawl104916713cra__wl
crazier183610743crazier
crazies183413853crazies
crazily2136923crazily
crazing193914583crazing
credal9311673cr_edal
creedal1037093creedal
crenel84213063cren_el
crestal9312133crestal
criminal1248303criminal
crinite9513633crinite
crinoidal1254413crinoidal
crissal937413crissal
critical12310263critical
cronies9622503cronies
cronish12310863cronish
crucian1146283crucian
crunodal1142913crunodal
crural8610633cr_ural
crustal939023crustal
cryptal1445683cryptal
crystal1237433crystal
cuneal8611513c_uneal
curial84019153c_urial
cyanic133110773cyani_c
cyanid123912033cyani_d
cyanide13298843cyanide
cyanids13297933cyanids
cyanin113911453cyani_n
cyanine122911513cyanine
cyanins122910013cyanins
cyanite122710763cyanite
cynical1437873c_ynical
denial74720513_denial
drail65020973dra_i_l
facial113615633_facial
finial92814183_finial
fractal1237623fractal
frail85220213fra_i_l
frazil1847223frazi_l
frontal1038363frontal
gavial10310083_gavial
genial74917613_genial
geranials1045913geranials
geraniol945143geraniol
gharial1137343gharial
glacial1038143glacial
graal64316503gra__al
gradual936943gradual
grail64622873gra_i_l
grana65722093gran_a_
grandad1038453grandad
grandam1139393grandam
granita82111303granita
granitas92610223granitas
granite82017083granite
granola837913granola
gremial1039153gremial
hernial10310433hernial
irenical1048553irenical
ironical1049963ironical
kraal94511823kra__al
labial84714343_labial
lanital7310913_lanital
mania75634143_mania_
maniac103917973_maniac
manias84029033_manias
manila84518303_manila
manual8313463_manual
martial92415413martial
menial84223033_menial
morainal1047193morainal
narial6317953_narial
nasial6413283_nasial
octantal1044563octantal
ordinal838633ordinal
ovarial1037613ovarial
partial92616263partial
penial84120893_penial
praedial1178763praedial
preanal9310713prean_al
preaxial1746973preaxial
predial103815413predial
quantal16367893quantal
rachial122012173_rachial
radiale83813523_radiale
radials83614633_radials
radian74117273_radian
radical103312793_radical
raia46638383_ra_ia_
raias54631123_ra_ias
rail46147763_ra_i_l
ramal74622243_ra_mal
randan7315253_randan
rani46640103_rani__
ranid66429333_rani_d
ranids75118703_ranids
ranis55235833_rani_s
ranula6311813_ranula
rascal8511123_rascal
ratal55025113_ra_tal
redial74923113_redial
renail65020763_renail
renal55929503_ren_al
rental63922023_rental
retial64724993_retial
rhinal9510183_rhinal
rial45938093_r__ial
sacrarial1146523sacrarial
sandal73317283_sandal
scandal1038673scandal
scrannel1044033scrannel
spacial1138763spacial
spaniel948923spaniel
spatial9310323spatial
tarnal63716503tarn_al
tragical1148213tragical
trail55126773tra_i_l
trangam1039333trangam
travail1036543travail
trenail7410803trenail
trial54926353tr__ial
triaxial1545663triaxial
trinal6516953trin_al
trivial1038713trivial
uracil8311543uraci_l
uranic82315183urani_c
uranide82212093uranide
uranism91112513uranism
uranite72515693uranite
uranium9610023uranium
uranyl936293uran_yl
uredial82910483uredial
urial54823023ur__ial
urinal6614123urin_al
vandal103713833_vandal
venial94218283_venial
xenial133414903_xenial
zoarial1646923zoarial

Search took 9 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.1561145455.1
2DLD Change Limit1340272798.17316398.8
3Display Results2792790.0933000.0
 (SQL Overall)1786912798.42221217.2
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.