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

265 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
ritual631062(None) 
rituals738351rituals
actual8311022actual
citral81113892citral
mitral81314322mitral
mutual838502mutual
ratal55025112rat_al
retial64724992retial
retral64419742retral
rial45938102ri__al
rictal83113192rictal
ritually1167482ritually
rival85216502ri_val
riyal84413432ri_yal
victual1246252victual
virtual1045912virtual
visual938802visual
vital84819672vit_al
withal1238932withal
annual64710703annual
antral65719413antral
arbitral1045423arbitral
artal55525483art_al
astral66919283astral
biaxal1536093biaxal
binal75323823bi_nal
bitmap1235613bitmap
bridal9511453bri_dal
brutal859383brut_al
casual81112873casual
chital114313883chit_al
citola838393citola
citrals91111673citrals
coital84117053coit_al
crissal937413crissal
critical12310263critical
dial55935073di__al
diquat1639763diquat
dismal92412243dismal
distal73615773distal
dita56032533dit_a_
ditas65923673dit_as
dotal64919623dot_al
dual55928173__dual
equal1449823_equal
estral64716513estral
estrual7367933estrual
factual1246723factual
fatal84819373fat_al
fetal85623373fet_al
fetial95716193fetial
fibula11258053fibula
figural1145243figural
filial93013253filial
final83922033fi_nal
finial92814183finial
fiscal1139333fiscal
fistula1045503fistula
fitful1256333fitful
futural1037283futural
gimbal11228813gimbal
gimmal11247513gimmal
gingal81010153gingal
gradual936943gradual
habitual1343493habitual
hiatal9310203hiatal
hiemal11339513hiemal
hitman112710223hitman
ideal65716393_ideal
ileal56118083_ileal
ilial55317843_ilial
initial7311883initial
irreal657833irreal
jingal1498593jingal
joual12311653_joual
kitbag1334973kitbag
kittel10368873kittel
lethal939803lethal
lienal63912793lienal
ligula7359673ligula
lineal65616033lineal
lingual8379083lingual
litai55216363lit_ai
litas54923773lit_as
literal7613273literal
litoral7610763litoral
litu47631573litu__
luteal64411483luteal
manual8313463manual
marital92314183marit_al
metal75427383met_al
miaul71612123miau_l
miskal123710263miskal
missal84314903missal
mistral91013643mistral
mutuals937133mutuals
mutuel837823mutuel
natal53921493nat_al
natural739513natural
nidal65217113ni_dal
nitril62511533nitril
nival84915773ni_val
notal55221353not_al
octal71214723oct_al
orbital936923orbit_al
osteal6312963osteal
petal76526893pet_al
pial65636713pi__al
pibal95217323pi_bal
pical95524373pi_cal
picul95015363picu_l
pineal84817693pineal
pinnal84814283pinnal
pipal95118353pi_pal
pita65436443pit_a_
pitas77427673pit_as
pitfall1245823pitfall
pitman102412123pitman
pitsaw1135613pitsaw
pitta75018693pitta_
pittas86014523pittas
primal104014623pri_mal
primula1145713primula
racial83419243racial
radial74020393radial
radula749313radula
raita54623073rait_a_
raitas64417673rait_as
ramal74622253r_amal
ranula6311813ranula
rascal8511123rascal
ratals64219583rat_als
ratan53722663rat_an
ratbag956563ratbag
ratel54224883rat_el
rattail737803rattail
rattan63613603rattan
real45750293r__eal
recital9412173recit_al
recoal84117983recoal
rectal84418143rectal
recusal968683recusal
redial74923113redial
refuel93912623refuel
refusal1056893refusal
refutal1046943refutal
regal65023793r_egal
regnal74812933regnal
remittal1046513remittal
renal55929513r_enal
rental63922033rental
repeal84718293repeal
reseal64819653reseal
residual9245443residual
retag63618413ret_ag
retail65522073retail
retax124517973ret_ax
reteam83214533reteam
retear63115483retear
retell63813643retell
retia55326113retia_
retinal75318353retinal
retool63914483retool
retotal739843retotal
retrial7615553retrial
retune69121953retune
return623222523return
retuse66617223retuse
reveal94115063reveal
revictual1442703revictual
rhinal9510203rhinal
ria36745513ri__a_
rials55026673ri__als
rias45540603ri__as
riata54618023riata_
riatas63915103riatas
ribald9209293ri_bald
ricrac1037013ricrac
rictus8379193rictu_s
ridgel8399973ridgel
ridgil8316823ridgil
riel46432393ri__el
rill45140913ri__ll
rioja1236303rioja_
riojas1335813riojas
riprap1055513riprap
ripsaw1134283ripsaw
ristra6310713ristra_
ristras7311563ristras
risus54216393risu_s
ritard74812083ritard
rite45849463rit__e
rites54442553rit_es
ritter63822423ritter
ritualism1156813ritualism
ritualist948643ritualist
ritualize1847793ritualize
ritz135129993rit__z
ritzes154812943ritzes
ritzily1945143ritzily
ritzy175611163rit_zy
rivals94213183ri_vals
riyals94111083ri_yals
rorqual1663573rorqual
rostral7311333rostral
rota45834343rot_a_
rotas54827723rot_as
rotl45029683rot__l
rotund737293rotund
royal85014703r_oyal
rugal65916093r_ugal
rural55821173r_ural
setal56430903set_al
sexual1338423sexual
sial45938843si__al
signal73711483signal
sisal54217733si_sal
sitar54820543sit_ar
situate7410783situate
situp74414063situ_p
situps8538783situps
situs55019233situ_s
spiritual1144253spiritual
spital83813873spit_al
steal56125473_steal
stull54916273_stull
sutural7310223sutural
tactual936203tactual
teal45546503__teal
textual1444603textual
tibial849843tibial
tical76021493ti_cal
tidal64516453ti_dal
timbal102510753timbal
tincal83913373tincal
tineal66216173tineal
tissual745193tissual
titan53318173tit_an
titian62512663titian
titman82711003titman
titular737523titular
total55321823tot_al
trial54926353tri__al
tribal8611133tri_bal
tribunal10104673tribunal
trinal6516963tri_nal
trivial1038713trivial
tubal75517203__tubal
ungual738183ungual
urial54823023uri__al
urinal6614123uri_nal
usual5310183_usual
vial76731103vi__al
victuals1344773victuals
vinal85725813vi_nal
vineal94814753vineal
viral86419593vi_ral
visuals1036863visuals
vita75828533vit_a_
vitae84217633vit_ae
vitals94514303vit_als
vitta85015173vitta_
vittae93911003vittae
witan83816503wit_an
wittol935923wittol

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.420425454.8
2DLD Change Limit1127162655.37620966.5
3Display Results2652650.0763486.8
 (SQL Overall)1786912655.87230431.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.