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

499 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
equal144982(None) 
equals1538691equals
aqua132813962aqua_
aquae142212712aquae
aquas142412612aquas
coequal1844932coequal
dual55928172_dual
egal55119432e_gal
equable1849252equable
equably2136182equably
equaled17166922equaled
equally1936862equally
equate152012462equate
equid154610322equid
equip16467262equip
joual12311652joual
qua124821972_qua_
quad144618702_quad
quag144815942_quag
quai134420392_quai
quail144314362_quail
quale143617852_quale
qualm163511182_qualm
quay164618352_quay
sequel1556712sequel
sexual1338412sexual
squab163810732squab
squad155110792squad
squall1537992squall
squat143720142squat
squaw17368982squaw
squeal1538012squeal
unequal1644482unequal
usual5310182usual
aal39058673__aal
actual8311023actual
aecial84817313aecial
aerial64625713aerial
ahull84010313ahull
al210674043___al
algal66518213algal
alula5317093alula
anal48037523_anal
annal56520763annal
annual64710703annual
anural65714743anural
appal95315223appal
areal55928733areal
argal65023383argal
artal55525473artal
arval86017013arval
asexual1443973asexual
aural54428963aural
axal116520493_axal
axial124515193axial
baal67033113_baal
bal56662723__bal
banal75925993banal
basal75722283basal
benzal1739643benzal
binal75323823binal
boral75831703boral
brumal1049503brumal
brutal859383brutal
bubal94218213bubal
buhl95518223_buhl
bull65634873_bull
burl64937183_burl
cabal95222153cabal
canal75428043canal
casual81112863casual
caudal91611483caudal
caul65630003cau_l
causal81413203causal
cecal94619113cecal
cedula977643cedula
censual937663censual
cental84420963cental
cercal10314123cercal
cereal8315833cereal
churl105913883churl
coal66939253_coal
coequals1944303coequals
comal95125133comal
copal95621783copal
coral76033453coral
coxal146116673coxal
craal74117753craal
cruel74815903cruel
crural8610633crural
cull65929643_cull
curl66035053_curl
dal47554953__dal
deal56347413_deal
decal85523233decal
dedal75719023dedal
defuel10348933defuel
denial74720513denial
dental74319173dental
dermal93614343dermal
dhal86719283_dhal
dial55935063_dial
diquat1639763diquat
domal85619203domal
dotal64919623dotal
doula65717773doula
duad66521413_duad
duals65620083_duals
ducal84816423ducal
duel56729703_duel
dull56430443_dull
dural64923893dural
ear36867883e__ar
earl45838143e_arl
easel54521113easel
eat36989053e__at
eau37450943e__au
eaux116618423eau_x
eclat7523603eclat
ecu56828233ecu__
ecus65421463ecu_s
educe84313453educe
educt85017103educt
eel37946843e__el
egad64215413e_gad
eggar7458883eggar
ekuele1034383ekuele
el26745293e___l
elan46734243e_lan
ell36735683e__ll
eluant6315093eluant
eluate62315433eluate
elude64517623elude
elute54822573elute
eluvial1045853eluvial
email74715093email
embalm1236643embalm
embar94011593embar
embay123410593embay
empale102611263empale
emu55929983emu__
emus66821683emu_s
enhalo987563enhalo
enol45823823e_nol
enrol51014283enrol
entail61114343entail
enuf7323843enu_f
enure53520223enure
epha9310053epha_
ephah1337063ephah
ephas10311543ephas
epical10413393epical
equaling1837793equaling
equalise1748213equalise
equality2046993equality
equalize2648023equalize
equalled1834863equalled
equated171910403equated
equates162012313equates
equator1637483equator
equids16439143equids
equine151711573equine
equips17387193equips
equity1838103equity
era35741503e_ra_
eras45441503e_ras
eruct74022353eruct
erugo6369853erugo
erupt74220063erupt
ervil8310303ervil
escar74011993escar
eskar9457453eskar
espial839543espial
essay867623essay
estral64716513estral
estrual7367933estrual
eta35834193e_ta_
etas46432273e_tas
ethyl1136513ethyl
etna46415263etna_
etnas54713933etnas
etude63612303etude
etui45416233etu_i
etuis54013133etuis
euro45325273e_uro
evil75318073e_vil
exalt123018533e_xalt
exam132514623e_xam
excel1437743excel
exequial2443023exequial
exhale1636873exhale
expat14313813expat
expel1448233expel
extol1247893extol
exude134010293exude
exult122814123exult
exurb1457703exurb
exuvial1744253exuvial
eyas76427433e_yas
eyra76217553eyra_
eyras84715923eyras
fatal84819373fatal
faucal11339963faucal
faunal94711593faunal
feal713940423_feal
fecal105119213fecal
fecial114714623fecial
fecula113310053fecula
feral85424653feral
ferial94621253ferial
ferula93011173ferula
festal94213563festal
fetal85623373fetal
fetial95716193fetial
feuar8310243feuar
feudal1037683feudal
final83922033final
foal76630923_foal
focal104917673focal
foul77027583fou_l
frugal1036393frugal
fuel76824733_fuel
fugal95613033fugal
full75229153_full
furl77030883_furl
gal46055513__gal
gayal9312713gayal
genial74917613genial
genua64614153genua_
glial66715433glial
goal55829303_goal
goral65125753goral
graal64316503graal
gruel66014743gruel
guan55325583_guan
guar56923293_guar
gul45832793_gu_l
gull54828453_gull
gyral94412783gyral
hadal95518123hadal
halal85623593halal
hamal104623103hamal
haul75530453hau_l
heal75645693_heal
hemal104419803hemal
herbal112513493herbal
horal86328673horal
hula74923753_hula
hull75428783_hull
hurl76029933_hurl
ideal65716393ideal
ileal56118083ileal
ilial55317833ilial
jacal14313703jacal
jejunal1342833jejunal
jouals1338923jouals
jugal135612403jugal
jural125120483jural
keypal1534893keypal
knurl9398913knurl
kraal94511823kraal
lauan55216793lauan
leal46043273_leal
legal65715943legal
lehua837953lehua_
lehuas935943lehuas
lethal939803lethal
local74820273local
loquat1558283loquat
loral55927823loral
loyal84513483loyal
luau44824163_luau
lull44225763_lull
manual8313463manual
maul64830713mau_l
meal65643173_meal
meatal84114733meatal
medal86221323medal
medial93819863medial
medusal1035183medusal
menial84223033menial
mensal84615653mensal
mental84521603mental
mescal104113483mescal
mesial84818083mesial
metal75427383metal
mezcal19367853mezcal
miaul71612123miaul
modal85919233modal
molal75120343molal
moral75533433moral
mull65128803_mull
mural75225103mural
mutual838503mutual
nasal56217593nasal
natal53921493natal
naval85315833naval
nebula857333nebula
neural6311993neural
nidal65217103nidal
nival84915773nival
nodal64717793nodal
nonequal1746043nonequal
nopal75517103nopal
notal55221353notal
nounal639813nounal
null45125313_null
nurl45327243_nurl
octal71214723octal
offal1136243offal
opal66923523_opal
oral47638123_oral
oval77119523_oval
pal56761673__pal
papal95820673papal
pausal81511963pausal
peal68648103_peal
pedal86022503pedal
penal75228373penal
penial84120893penial
perusal939193perusal
petal76526893petal
phial10313203phial
pial65636703_pial
pibal95217323pibal
pical95524373pical
pipal95118353pipal
plural839823plural
prequel1836343prequel
pul56138063_pu_l
pula65129373_pula
pull64731663_pull
pupal97616873pupal
purl65631423_purl
qat125253333_q_at
quack203812503_quack
quads154515843_quads
quaff201311353_quaff
quags154613253_quags
quails153412643_quails
quais144618393_quais
quake184114643_quake
quaky214310743_quaky
qualia1559563_qualia
qualms17317243_qualms
qualmy20285803_qualmy
quant143624813_quant
quare143920543_quare
quark184614123_quark
quart144027853_quart
quash174512163_quash
quasi144015023_quasi
quass144413763_quass
quate144521413_quate
quays174612043_quays
quean143612843_quean
quell144311423_quell
quey164616473_quey
quezal2435143_quezal
quid144922353_quid
quill148413763_quill
quilt144125103_quilt
quin135823923_quin
quip154818623_quip
quit136136513_quit
quiz224920003_quiz
quod145413623_quod
quoll14379493_quoll
ramal74622243ramal
ratal55025113ratal
real45750293_real
recoal84117973recoal
rectal84418133rectal
recusal968673recusal
redial74923113redial
refuel93912623refuel
refusal1056893refusal
refutal1046943refutal
regal65023793regal
regnal74812933regnal
renal55929503renal
rental63922023rental
repeal84718283repeal
requin15310713requin
requital1745053requital
reseal64819643reseal
retial64724993retial
retral64419743retral
reveal94115053reveal
rial45938093_rial
ritual6310613ritual
rival85216503rival
riyal84413433riyal
rorqual1663573rorqual
royal85014703royal
rugal65916093rugal
rural55821173rural
sabal75422483sabal
sal36462883__sal
salal55425703salal
saul45836523sau_l
scull75315763scull
seal45654373_seal
sendal73314993sendal
sensual738053sensual
sepal77723003sepal
septal84513383septal
sequela1663993sequela
sequels1665703sequels
sequin1538523sequin
seral56336383seral
serial64625853serial
serumal938783serumal
serval93913413serval
setal56430903setal
shaul85418103shaul
sheal84927703sheal
shoal83920263shoal
shul75823153shu_l
sial45938833_sial
sisal54217733sisal
skoal93811453skoal
skua86113153skua_
skuas95611733skuas
skull94812033skull
soul46435713sou_l
squabs17429323squabs
squads164410293squads
squalid1737043squalid
squalls1647303squalls
squally1937663squally
squalor1644423squalor
squama1736533squama
square154513353square
squark19438113squark
squash1846833squash
squatly1946423squatly
squats153712963squats
squawk22385373squawk
squaws18438783squaws
squeak1935253squeak
squeals1636503squeals
squeg1588033squeg
squib163710493squib
squid154211903squid
squill1537223squill
steal56125473steal
stull54916273stull
sural55931263sural
tamal73522613tamal
teal45546503_teal
tectal83713253tectal
tegua6109563tegua_
teguas768013teguas
telial65815363telial
tepal76319583tepal
tequila1644583tequila
tergal72912833tergal
textual1444603textual
thurl84912683thurl
tical76021493tical
tidal64516443tidal
tonal53724303tonal
total55321823total
trial54926353trial
trull54012673trull
tubal75517203tubal
typal105311153typal
unequals1743723unequals
ungual738183ungual
ureal56722683ureal
urial54823023urial
usuals637783usuals
uveal84411073uveal
uvula845153uvula
vagal94613633vagal
vasal85516293vasal
veal76936813_veal
veinal93812963veinal
venal85523213venal
venial94218283venial
verbal112513663verbal
vernal93514213vernal
versal93013753versal
vestal94615573vestal
vial76731093_vial
vinal85725813vinal
viral86419593viral
visual938803visual
vital84819673vital
vocal104715643vocal
waul76927313wau_l
weal75838683_weal
wheal115716183wheal
xenial133414903xenial
yuan76120013_yuan
zeal135530333_zeal
zoeal144813783zoeal
zonal145116853zonal

Search took 5 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 Filter178691836670.1401276364.3
2DLD Change Limit836674993.82621868.0
3Display Results4994990.1403564.3
 (SQL Overall)1786914994.10643519.5
 
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.