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

395 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
xenial13341490(None) 
denial74720511denial
genial74917611genial
menial84223031menial
penial84120891penial
venial94218281venial
xenia124814771xenia_
xenias133712971xenias
aecial84817312aecial
aerial64625712aerial
benzal1739642benzal
cental84420962cental
denials84114132denials
dental74319172dental
fecial114714622fecial
ferial94621252ferial
fetial95716192fetial
finial92814182finial
genital849792genital
hernial10310432hernial
medial93819862medial
menials94015682menials
mensal84615652mensal
mental84521602mental
mesial84818082mesial
penal75228372pen_al
redial74923112redial
renail65020762renail
renal55929502ren_al
rental63922022rental
retial64724992retial
sendal73314992sendal
serial64625852serial
telial65815362telial
tenail64516102tenail
tenia55324482tenia_
teniae64517352teniae
tenias64720072tenias
veinal93812962veinal
venal85523212ven_al
xenic144114642xeni_c
achenial1348283achenial
aecia73819283aecia_
aeonian738353aeonian
aerials74017553aerials
agential958153agential
agnail739523agnail
amnia75918643amnia_
anal48037523_an_al
anil46437433_ani_l
animal85016253_animal
annal56520763_annal
anneal64812293anneal
annual64710703annual
apneal83411123apneal
atrial65418943atrial
audial7312993audial
axenic154210003axeni_c
axial124515193_axial
axonal1347653axon_al
banal75925993ban_al
banian8315383banian
benday123810813benday
benign938313benign
benthal1247953benthal
benzol1756993benzol
benzyl2034163benzyl
bestial9311643bestial
bewail1189583bewail
bezil163812883bezi_l
biennial1065093biennial
binal75323823bin_al
burial84117623burial
canal75428043can_al
cantal84122033cantal
cecal94619113ce_cal
ceil65725063ce_i_l
celiac101910433celiac
censual937663censual
centai84814783centai
centals94317053centals
centas85020703centas
central93114473central
cercal10314123cercal
cereal8315833cereal
ceria75125353ceria_
cerias83321973cerias
clinal8311553clinal
conical11316203conical
cranial92114683cranial
cuneal8611513cuneal
curial84019153curial
cynical1437873cynical
deal56347413de__al
decal85523233de_cal
decimal1238083decimal
decrial10310323decrial
dedal75719023de_dal
deil56231623de_i_l
denar65223293den_ar
deni56929393deni__
deniable11312083deniable
deniably1448553deniably
denied84318633denied
denier74420693denier
denies74729643denies
denim85518843deni_m
denims95214323denims
dentals83915393dentals
dentil74017883dentil
dentinal939503dentinal
derail74218813derail
dermal93614343dermal
detail74516433detail
devil94714733devi_l
devisal1136913devisal
dial55935063__dial
egal55119433_e_gal
email74715103_email
encinal949243_encinal
enhalo987563_enhalo
enisle63412093_enisle
enol45823823_en_ol
enrol51014283_enrol
entail61114343_entail
entia5318203_entia_
eonian6311833eonian
epical10413393_epical
equal1449823_equal
espial839543espial
evil75318073_evi_l
exequial2443023exequial
exuvial1744253exuvial
facial113615633facial
feal713940423fe__al
fecal105119213fe_cal
fecials123510333fecials
fennel9429473fennel
feral85424653fe_ral
feria85922713feria_
feriae95618603feriae
ferias95020393ferias
festal94213563festal
fetal85623373fe_tal
fetials103711743fetials
feudal1037683feudal
filial93013253filial
final83922033fin_al
finials103210153finials
finical1239693finical
fontal9313143fontal
fungal10388733fungal
gavial10310083gavial
geminal10109893geminal
general81010933general
genially12129523genially
genic85119393geni_c
genie66124923geni_e
genies75324943genies
genii64514173geni_i
genip84415203geni_p
genipap1243123genipap
genips9469943genips
genitals937243genitals
genius74512923genius
genoa64315823genoa_
genoas74013623genoas
gentian8310103gentian
gentil74115123gentil
genua64614153genua_
geoidal936703geoidal
geranial949283geranial
gingal81010143gingal
glial66715433_glial
gonia64117533gonia_
gremial1039153gremial
heal75645693he__al
heil76328933he_i_l
heliac111010893heliac
helical12311153helical
hemal104419803he_mal
henna84414043henna_
hennas94211803hennas
herbal112513493herbal
hernia9312293hernia_
herniae1039043herniae
hernias10310773hernias
hymenial1645293hymenial
ilial55317843_ilial
inia45024703_inia_
irenical1048553irenical
jezail2234643jezail
jingal1498583jingal
jovial1636543jovial
kenaf12316033ken_af
kennel10369213kennel
kevil12399863kevi_l
keypal1534893keypal
labial84714343labial
lanital7310913lanital
leal46043273le__al
legal65715943le_gal
lenis56326863leni_s
lenite6719983lenite
lenity9612713lenity
lentil64315393lentil
lethal939803lethal
lexical1637363lexical
lienal63912783lien_al
lineal65616023lineal
mania75634143mania_
maniac103917973maniac
manias84029033manias
manila84518303manila
manual8313463manual
meal65643173me__al
meatal84114733meatal
medal86221323me_dal
media84721713media_
mediad104313713mediad
mediae94217413mediae
medials103914733medials
median94117543median
medias93620783medias
medical12312513medical
menad85918983men_ad
menially131111093menially
meninx1538703meninx
meniscal1246183meniscal
mensa75318663mensa_
mensae84114043mensae
mensas85115853mensas
menta74424423menta_
mescal104113483mescal
mesian84315503mesian
metal75427383me_tal
metical11315363metical
mezcal19367853mezcal
minimal114010593minimal
nail45838653__nail
narial6317953narial
nasial6413283nasial
neural6311993neural
nidal65217103__nidal
nil36144193__ni_l
nill45634303__nill
nival84915773__nival
oedipal1045173oedipal
omental93210413omental
peal68648103pe__al
pedal86022503pe_dal
pencel103812913pencel
pencil103712973pencil
penicil1138833penicil
penile82219603penile
penis75129323peni_s
penman10312323penman
penna74520203penna_
pennae84314033pennae
pennia84412973pennia_
pensil83013333pensil
pentad9313763pentad
pentyl1138813pentyl
peril75425953peri_l
petal76526893pe_tal
phial10313203_phial
pial65636703__pial
pineal84817683pineal
pinnal84814273pinnal
predial103815413predial
racial83419243racial
radial74020393radial
real45750293re__al
rebill84713253rebill
recital9412163recital
recoal84117973recoal
rectal84418133rectal
redia65524483redia_
rediae74221993rediae
redials84416883redials
redias74523603redias
refill94514053refill
regal65023793re_gal
reginal84814293reginal
regnal74812933regnal
remail85017123remail
renails74917263renails
renewal1038703renewal
renig64518913reni_g
renigs74314593renigs
renin54830033reni_n
renins64526453renins
rentals74017473rentals
reoil55321183reoi_l
repeal84718283repeal
resail64418733resail
reseal64819643reseal
retail65522073retail
retia55326113retia_
retinal75318353retinal
retral64419743retral
retrial7615553retrial
reveal94115053reveal
revisal1038263revisal
revival1337033revival
rhinal9510183rhinal
rial45938093__rial
sandal73317283sandal
scenical1247133scenical
seal45654373se__al
seminal91213403seminal
sendals81912263sendals
senile63420213senile
senior63214043senior
seniti64317213seniti
senna54617983senna_
sennas64214233sennas
sensa54117473sensa_
sensual738053sensual
sepal77723003se_pal
sepia75318673sepia_
sepias83616103sepias
septal84513383septal
serail64222673serail
seral56336383se_ral
serials73919743serials
serval93913413serval
setal56430903se_tal
sexennial1643483sexennial
sexual1338413sexual
sial45938833__sial
snail57020203_snail
social8813333social
special11310303special
spinal84915313spinal
splenial1047183splenial
sundial859863sundial
taenia6313193taenia_
taeniae739083taeniae
taenias7311283taenias
teal45546503te__al
tectal83713253tectal
telia55821143telia_
tenails73713923tenails
tenurial847703tenurial
tepal76319583te_pal
tergal72912833tergal
tertial7313853tertial
thenal92712413then_al
tibial849843tibial
tincal83913353tincal
tineal66216153tineal
toenail738773toenail
tonal53724303ton_al
trenail7410803trenail
trial54926353_trial
trinal6516953trinal
uncial83715223uncial
ungenial946973ungenial
unnail6410583unnail
uredial82910483uredial
urial54823023_urial
urinal6614123urinal
uxorial1446323uxorial
vandal103713833vandal
veal76936813ve__al
veil75523593ve_i_l
vena76126293ven_a_
venae85920983ven_ae
venially1499423venially
venin85118663veni_n
venine93718433venine
venins93816703venins
venire93513693venire
ventail10310453ventail
ventral103612173ventral
verbal112513663verbal
vernal93514213vernal
versal93013753versal
vesical12159813vesical
vestal94615573vestal
vexil1538963vexi_l
vial76731093__vial
vinal85725813vin_al
vineal94814743vineal
weal75838683we__al
xenon122612453xen_on
xenons132710483xenons
xeric144315663xeri_c
yenta83917043yenta_
yentas94614213yentas
zeal135530333ze__al
zenith1839073zenith
zenithal2093333zenithal
zonal145116853zon_al

Search took 8 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.1231452772.4
2DLD Change Limit1127163956.70316815.8
3Display Results3953950.1432762.2
 (SQL Overall)1786913956.96925640.8
 
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.