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

425 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
normal8321353(None) 
formal113215201formal
normals92510901normals
abnormal1244092abnormal
aortal65217512aortal
boral75831702bor_al
boreal84817212boreal
bromal10313652bromal
comal95125132co_mal
coral76033452cor_al
cormel103815602cormel
corral83616252corral
dermal93614342dermal
domal85619202do_mal
dorsal74613942dorsal
formals123312892formals
format113021352format
formol112910332formol
formyl14276442formyl
goral65125752gor_al
horal86328682hor_al
informal1355642informal
korma115913072korma_
kormas124511232kormas
loral55927822lor_al
loreal63814312loreal
moral75533432mor_al
mortal84616852mortal
narial6317952narial
narwal938942narwal
nodal64717792no_dal
noma67529462no_ma_
nomad86016182no_mad
nomas74726412no_mas
nonman8412362nonman
nopal75517102no_pal
noria55722182noria_
norias65518202norias
norm66429812norm__
normalcy1543382normalcy
normally1347882normally
normed95014542normed
norms76019312norm_s
notal55221352no_tal
nounal639812nounal
oral47638122_or_al
portal84218462portal
wormil1138042wormil
abnormals1342773abnormals
aboral8314373abor_al
aerial64625713aerial
airmail946213airmail
airman82414223airman
amoral8314633amor_al
animal85016253animal
anodal72512123ano_dal
anomaly1238843ano_maly
anorak1038923anor_ak
antral65719413antr_al
anural65714743anur_al
aorta55922573aorta_
aortae65115473aortae
aortas65417783aortas
areal55928733_areal
argal65023393_argal
aroma71220143aroma_
aromas81018613aromas
artal55525473_artal
arval86017013_arval
atrial65418943atrial
aural54428963aur_al
barbal104016663barbal
barman103519703barman
bora66141633bor_a_
borals86721913bor_als
boras75938303bor_as
borax145918723bor_ax
bordel94514573bordel
boreas85421733boreas
borstal939043borstal
bowman13129853bowman
bromals1139743bromals
brumal1049503brumal
burial84117623burial
bursal84414823bursal
carman103920743carman
carnal83919213carnal
carpal103716253carpal
ceramal1138843ceramal
cercal10314123cercal
cereal8315833cereal
choral115118493chor_al
chordal13449883chordal
choreal124412223choreal
chorial124214143chorial
coal66939253co__al
coaxal15387303coaxal
coccal9310223coccal
coeval1138893coeval
coital84117053coital
coma87134853co_ma_
comae97128423co_mae
comas95833003co_mas
comma114514793comma_
commas124814573commas
conformal1696273conformal
copal95621783co_pal
corals85325143cor_als
corban10314693corban
corbel103715973corbel
cordial10312953cordial
coria75828323coria_
corm85735383corm__
cormels113813373cormels
corms95626223corm_s
corneal94414503corneal
cornel84020053cornel
cornmeal1245853cornmeal
cornual94210173cornual
coronal94115763coronal
corrals93713853corrals
corsac10410173corsac
coryzal2154823coryzal
costal85419513costal
cowman13910373cowman
coxal146116673co_xal
craal74117753_craal
curial84019153curial
curtal83914543curtal
derma84918513derma_
dermas94116813dermas
dismal92412243dismal
dogma96112463dogma_
dogmas105011243dogmas
dolma86214173dolma_
dolman95312403dolman
dolmas95213043dolmas
doorman1037063doorman
doormat1059073doormat
dorm76834633dorm__
dormant102814373dormant
dormer94415903dormer
dormie9312623dormie
dormin9312313dormin
dorms85723843dorm_s
dormy115817473dorm_y
dorsa64617283dorsa_
dorsad8408973dorsad
dorsals84110843dorsals
dorsel75315503dorsel
dossal75510303dossal
dotal64919623do_tal
douma85817703douma_
doumas95314813doumas
dural64923893dur_al
enorm74415643enorm__
farfal123410183farfal
feral85424653fer_al
ferial94621253ferial
firman112211343firman
floral94313813flor_al
foal76630923fo__al
focal104917673fo_cal
foeman11311233foeman
foetal9311883foetal
fontal9313143fontal
fora75937393for_a_
foram105124933for_am
forams115115913forams
foray115023973for_ay
forbad122710503forbad
foreman12312363foreman
forgat104018583forgat
form95836873form__
formable1539503formable
formably1846663formably
formalin1347313formalin
formally1638243formally
formant123416003formant
formate123115093formate
formats123113573formats
forme105225993form_e
formed125021173formed
formee113919943formee
former114221403former
formes114623713formes
formful1545183formful
formic13310453formic
formols12299413formols
forms105327053form_s
formula1246293formula
formyls15235703formyls
foveal1237703foveal
german9611983german
gimmal11247513gimmal
goal55829303go__al
gooral7310463gooral
gorals76917653gor_als
gorm75529393gorm__
gormand1157453gormand
gormed105013833gormed
gorms85619593gorm_s
graal64316503_graal
gyral94412783gyr_al
haemal113811643haemal
hamal104623113_hamal
hammal134512063hammal
hartal9415473hartal
hemal104419803_hemal
herbal112513493herbal
herma105318883herma_
hermae115314473hermae
hermai118912863hermai
hiemal11339503hiemal
hora76136563hor_a_
horah117922053hor_ah
horas86333103hor_as
hormonal1346633hormonal
intimal9109943intimal
irreal657833irreal
joram145816983jor_am
jorams154810533jorams
jordan1468063jordan
joual12311653jo_ual
journal1484963journal
jovial1636543jovial
jural125120483jur_al
karma113415003karma_
karmas123013733karmas
kora86431553kor_a_
korai97018523kor_ai
koras95927113kor_as
korat94934433kor_at
kraal94511823_kraal
larval948503larval
local74820273lo_cal
lognormal1252443lognormal
loran55925093lor_an
louma76213633louma_
loumas84812333loumas
loyal84513483lo_yal
mammal95112753mammal
manorial10311083manorial
merman10513863merman
modal85919243mo_dal
molal75120343mo_lal
momma85111053momma_
mommas94110653mommas
mora66641273mor_a_
morae75831193mor_ae
morale85220553mor_ale
morals85324633mor_als
moras76438783mor_as
moray105423793mor_ay
morel75729093mor_el
morgan9311373morgan
morsel85815893morsel
mortals93914003mortals
mortar83812043mortar
morula8710473morula
mural75225113mur_al
narwals1036983narwals
narwhal1344333narwhal
nasal56217593n_asal
nasial6413283nasial
natal53921493n_atal
naval85315833n_aval
nema65522523n_ema_
nemas75321573n_emas
nerol51017813ner_ol
neural6311993neural
nidal65217103n_idal
nival84915773n_ival
nodical1049863nodical
noel45226553no__el
noil46133243no__il
nom510450643no_m__
nomads94711603no_mads
nome66038423no_m_e
nomen75621623no_men
nomes74933123no_mes
nominal92712373nominal
nomoi76012533no_moi
nomos75919743no_mos
noms65636403no_m_s
nona46929063no_na_
nonas55126653no_nas
nonfan948293nonfan
nonfat9512183nonfat
nonformal1486483nonformal
nongay10169153nongay
nonmeat9312773nonmeat
nonmen8412833nonmen
nonmetal1049643nonmetal
nonmodal1146593nonmodal
nonmoral1049233nonmoral
nonnormal1185963nonnormal
nonoral7313603nonoral
nonpar8168993nonpar
nonrival1146623nonrival
nonroyal1145753nonroyal
nonrural847363nonrural
nontax1348413nontax
nonwar9159423nonwar
nonyl849773no_nyl
nopals84914023no_pals
nor38048823nor___
nordic939473nordic
nori47133143nor__i
noris54928273nor_is
norite63221133norite
norland837163norland
normalise11259423normalise
normality1447203normality
normalize203010103normalize
normande1145943normande
north86018273nor_th
norths96812323norths
nota46830773no_ta_
notarial8410753notarial
nougat74712653nougat
noumenal1046173noumenal
nova76518953no_va_
novae85913123no_vae
novas85215363no_vas
novel85615993no_vel
novercal1345683novercal
noway111112843no_way
nuchal11218873nuchal
nurl45327243nur__l
octal71214723_octal
offal1136243_offal
oorali6311263oor_ali
opal66923523_o_pal
ora37250833_or_a_
orad56031693_or_ad
orals55826483_or_als
orca65522773_orca_
orcas75918623_orcas
ordeal779253_ordeal
oread64619603_oread
organ6915393_organ
oriel54920423_oriel
ormer75218373_ormer
ormolu845833_ormolu
orra46120723_orra_
osmol7138573_osmol
oval77119523_o_val
parral85517533parral
pommel12277453pommel
portals94015563portals
postal84317533postal
potman102813573potman
primal104014623primal
ramal74622243_ramal
real45750293__real
rial45938093__rial
rodman949713rodman
roman75424823ro_man
rorqual1663573rorqual
royal85014703ro_yal
rural55821173rur_al
seral56336383ser_al
serial64625863serial
serumal938783serumal
serval93913413serval
snorkel1135423snorkel
snowman12226623snowman
social8813333social
socman1039813socman
soma65635293so_ma_
soman75024903so_man
somas76030373so_mas
sora45746913sor_a_
soras55041013sor_as
sorel56231443sor_el
sororal7310653sororal
sorrel6413553sorrel
sorta57125413sorta_
sporal82915453spor_al
stomal85213313stomal
stromal93010593stromal
subnormal1343643subnormal
sural55931263sur_al
tamal73522623_tamal
tarmac10310333tarmac
tarnal63716503tarnal
tarsal63315273tarsal
tergal72912833tergal
thermal125010973thermal
toman75724053to_man
tombal102311023tombal
tonal53724303to_nal
tora47545993tor_a_
torah87125273tor_ah
toras55540373tor_as
torta55925353torta_
tortas64918253tortas
torula6610393torula
total55321823to_tal
trial54926353_trial
unmoral948693unmor_al
unreal64414453unreal
ureal56722683_ureal
urial54823023_urial
uxorial1446323uxorial
verbal112513663verbal
vernal93514213vernal
versal93013753versal
viral86419593vir_al
vocal104715643vo_cal
wadmal1237283wadmal
woman105818003wo_man
workman1635613workman
worm96129493worm__
wormed124314303wormed
wormer114514913wormer
wormils1236733wormils
worms105320763worm_s
wormy137514253worm_y
zoarial1646923zoarial
zoeal144813783zo_eal
zonal145116853zo_nal
zoonal1558083zoonal
zoril143916693zor_il

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 Filter1786911127160.390458182.1
2DLD Change Limit1127164255.65619928.6
3Display Results4254250.1403035.7
 (SQL Overall)1786914256.18628886.4
 
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.