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 “rial” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

262 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
rial4593810(None) 
dial55935071dial
pial65636711pial
rail46147761rail
real45750291real
ria36745511ria_
rials55026671rials
rias45540601rias
riel46432391riel
rill45140911rill
rival85216501rival
riyal84413431riyal
sial45938841sial
trial54926351trial
urial54823021urial
vial76731101vial
aal39058672_aal
aerial64625712aerial
ail37171052ai_l
al210674042__al
anal48037522anal
areal55928732areal
argal65023392argal
aria46245422aria_
arias55438022arias
ariel55228972ariel
aril45843022ari_l
artal55525472artal
arval86017012arval
atrial65418942atrial
axal116520492axal
axial124515192axial
baal67033112baal
bail65042802bail
bal56662722_bal
biali73419072biali
bialy105119322bialy
bias64738172bias
bill67239952bill
binal75323822binal
birl65830482birl
brail75525552brail
briar75718152briar
bridal9511452bridal
brill74819952brill
burial84117622burial
ciao64924192ciao
coal66939252coal
craal74117752craal
curial84019152curial
dal47554952_dal
deal56347412deal
dhal86719282dhal
dials64925342dials
diel59034612diel
dill55239982dill
diol57329142diol
dirl57430032dirl
drail65020972drail
drill64718262drill
dual55928172dual
egal55119432egal
fail74840242fail
feal713940422feal
ferial94621252ferial
fiar76427342fiar
fiat76646652fiat
fil65447152fi_l
fila74729142fila
fill75540202fill
final83922032final
foal76630922foal
frail85220212frail
friar85414272friar
frill84917562frill
gal46055512_gal
gill56336192gill
girl56226562girl
glial66715432glial
goal55829302goal
graal64316502graal
grail64622872grail
grill64617892grill
hail74839062hail
heal75645692heal
hila76228362hila
hill76439502hill
ilial55317842ilial
ill37437102_ill
jail115529092jail
jiao115017852jiao
jill116430272jill
kail85131502kail
kill85533192kill
kraal94511822kraal
krill94213652krill
leal46043272leal
liar47229692liar
mail65543452mail
meal65643172meal
miaul71612122miaul
mil55752122mi_l
mill66541492mill
nail45838652nail
narial6317952narial
nidal65217112nidal
nil36144202ni_l
nill45634312nill
nival84915772nival
oil37452062oi_l
opal66923522opal
oral47638122oral
oriel54920422oriel
oval77119522oval
pail66141832pail
pal56761672_pal
peal68648102peal
phial10313202phial
pia56848042pia_
pian66136102pian
pias66542562pias
pibal95217322pibal
pical95524372pical
pill65339472pill
pipal95118352pipal
prill74117942prill
primal104014622primal
racial83419242racial
rad47662012r_ad
radial74020392radial
rag45761322r_ag
rah68052402r_ah
rai37658222r_ai
raia46638382raia
raias54631122raias
raid55243082raid
rails55937402rails
rain46251732rain
rais45252622rais
raj105740222r_aj
rale45050562r_ale
ram56867272r_am
ramal74622242ramal
ran38266622r_an
rap56261962r_ap
ras37575392r_as
rat37892742r_at
ratal55025112ratal
raw67252252r_aw
rax108445722r_ax
ray66361992r_ay
read55942532read
realm75621622realm
reals55038652reals
ream65841612ream
reap65934742reap
rear45644552rear
redial74923112redial
reel45240532reel
regal65023792regal
renal55929512renal
retial64724992retial
rhinal9510202rhinal
rialto638602rialto
riant55833152riant
riata54618022riata
rib56848042ri_b
ribald9209292ribald
ribs65833032ribs
rice64942922rice
rich97025552rich
rick107334662rick
rictal83113192rictal
rid46754642ri_d
ride55945142ride
rids56539562rids
riels55121332riels
rif65951572ri_f
rife74632332rife
riff104430112riff
rifle85518332rifle
rifs74929012rifs
rift75642342rift
rig46748132ri_g
rigs55137602rigs
rile45650542rile
rille55728732rille
rills55032712rills
rim56052282ri_m
rime65138892rime
rims65936312rims
rimy96621292rimy
rin36663192ri_n
rind56535612rind
ring56541162ring
rink87737002rink
rins46153202rins
riot45947222riot
rip56851312ri_p
ripe66038932ripe
rips66237442rips
rise45945242rise
risk85724112risk
rite45849462rite
ritual6310622ritual
ritz135129992ritz
rivals94213182rivals
rive75537732rive
riyals94111082riyals
road56332112road
roam67132412roam
roan47234202roan
roar46328572roar
roil46235292roil
roll46331652roll
rotl45029682rotl
royal85014702royal
rugal65916092rugal
rural55821172rural
rya67622012rya_
ryas77224612ryas
sail45447162sail
sal36462882_sal
seal45654372seal
serial64625862serial
sials54227242sials
sill45545162sill
sisal54217732sisal
tail45443652tail
teal45546502teal
tical76021492tical
tidal64516452tidal
til36350272ti_l
till45941212till
tirl45029932tirl
trail55126772trail
triac74116372triac
triad65217722triad
trials64319882trials
tribal8611132tribal
trill55122932trill
trinal6516962trinal
triol55521362triol
ureal56722682ureal
urials64415192urials
urinal6614122urinal
vail75432552vail
veal76936812veal
via65636252via_
vials85822382vials
vill75235082vill
vinal85725812vinal
viol76523602viol
viral86419592viral
virl76224482virl
vital84819672vital
wail75238822wail
weal75838682weal
will75737522will
yill75628982yill
zeal135530332zeal
zill135727622zill

Search took 2 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 Filter178691298720.296603685.8
2DLD Change Limit298722620.94031778.7
3Display Results2622620.0604366.7
 (SQL Overall)1786912621.296137878.9
 
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.