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
rial4593809(None) 
dial55935061dial
pial65636701pial
rail46147761rail
real45750291real
ria36745501ria_
rials55026671rials
rias45540591rias
riel46432381riel
rill45140901rill
rival85216501rival
riyal84413431riyal
sial45938831sial
trial54926351trial
urial54823021urial
vial76731091vial
aal39058672_aal
aerial64625712aerial
ail37171042ai_l
al210674042__al
anal48037522anal
areal55928732areal
argal65023382argal
aria46245422aria_
arias55438022arias
ariel55228972ariel
aril45843022ari_l
artal55525472artal
arval86017012arval
atrial65418942atrial
axal116520492axal
axial124515192axial
baal67033112baal
bail65042802bail
bal56662722_bal
biali73419072biali
bialy105119322bialy
bias64738162bias
bill67239942bill
binal75323822binal
birl65830472birl
brail75525552brail
briar75718152briar
bridal9511452bridal
brill74819952brill
burial84117622burial
ciao64924182ciao
coal66939252coal
craal74117752craal
curial84019152curial
dal47554952_dal
deal56347412deal
dhal86719282dhal
dials64925342dials
diel59034602diel
dill55239972dill
diol57329132diol
dirl57430022dirl
drail65020972drail
drill64718262drill
dual55928172dual
egal55119432egal
fail74840242fail
feal713940422feal
ferial94621252ferial
fiar76427332fiar
fiat76646642fiat
fil65447142fi_l
fila74729132fila
fill75540192fill
final83922032final
foal76630922foal
frail85220212frail
friar85414272friar
frill84917562frill
gal46055512_gal
gill56336182gill
girl56226552girl
glial66715432glial
goal55829302goal
graal64316502graal
grail64622872grail
grill64617892grill
hail74839062hail
heal75645692heal
hila76228352hila
hill76439492hill
ilial55317842ilial
ill37437092_ill
jail115529092jail
jiao115017842jiao
jill116430262jill
kail85131492kail
kill85533172kill
kraal94511822kraal
krill94213642krill
leal46043272leal
liar47229682liar
mail65543442mail
meal65643172meal
miaul71612122miaul
mil55752112mi_l
mill66541482mill
nail45838652nail
narial6317952narial
nidal65217102nidal
nil36144192ni_l
nill45634302nill
nival84915772nival
oil37452052oi_l
opal66923522opal
oral47638122oral
oriel54920422oriel
oval77119522oval
pail66141832pail
pal56761672_pal
peal68648102peal
phial10313202phial
pia56848032pia_
pian66136092pian
pias66542552pias
pibal95217322pibal
pical95524372pical
pill65339462pill
pipal95118352pipal
prill74117942prill
primal104014622primal
racial83419242racial
rad47662002r_ad
radial74020392radial
rag45761322r_ag
rah68052402r_ah
rai37658222r_ai
raia46638382raia
raias54631122raias
raid55243072raid
rails55937402rails
rain46251732rain
rais45252622rais
raj105740222r_aj
rale45050562r_ale
ram56867272r_am
ramal74622242ramal
ran38266612r_an
rap56261962r_ap
ras37575392r_as
rat37892742r_at
ratal55025112ratal
raw67252252r_aw
rax108445722r_ax
ray66361992r_ay
read55942532read
realm75621622realm
reals55038652reals
ream65841612ream
reap65934742reap
rear45644552rear
redial74923112redial
reel45240532reel
regal65023792regal
renal55929502renal
retial64724992retial
rhinal9510182rhinal
rialto638602rialto
riant55833152riant
riata54618022riata
rib56848032ri_b
ribald9209292ribald
ribs65833022ribs
rice64942912rice
rich97025542rich
rick107334652rick
rictal83113172rictal
rid46754622ri_d
ride55945122ride
rids56539542rids
riels55121332riels
rif65951562ri_f
rife74632322rife
riff104430102riff
rifle85518332rifle
rifs74929002rifs
rift75642332rift
rig46748122ri_g
rigs55137592rigs
rile45650532rile
rille55728732rille
rills55032712rills
rim56052272ri_m
rime65138882rime
rims65936302rims
rimy96621282rimy
rin36663182ri_n
rind56535602rind
ring56541152ring
rink87736992rink
rins46153192rins
riot45947212riot
rip56851302ri_p
ripe66038922ripe
rips66237432rips
rise45945232rise
risk85724102risk
rite45849452rite
ritual6310612ritual
ritz135129982ritz
rivals94213182rivals
rive75537722rive
riyals94111082riyals
road56332112road
roam67132412roam
roan47234202roan
roar46328572roar
roil46235292roil
roll46331652roll
rotl45029682rotl
royal85014702royal
rugal65916092rugal
rural55821172rural
rya67622012rya_
ryas77224612ryas
sail45447162sail
sal36462882_sal
seal45654372seal
serial64625852serial
sials54227242sials
sill45545152sill
sisal54217732sisal
tail45443652tail
teal45546502teal
tical76021492tical
tidal64516442tidal
til36350262ti_l
till45941202till
tirl45029922tirl
trail55126772trail
triac74116372triac
triad65217722triad
trials64319882trials
tribal8611132tribal
trill55122932trill
trinal6516952trinal
triol55521362triol
ureal56722682ureal
urials64415192urials
urinal6614122urinal
vail75432552vail
veal76936812veal
via65636242via_
vials85822382vials
vill75235072vill
vinal85725812vinal
viol76523592viol
viral86419592viral
virl76224472virl
vital84819672vital
wail75238822wail
weal75838682weal
will75737512will
yill75628972yill
zeal135530332zeal
zill135727612zill

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.0602978183.3
2DLD Change Limit298722620.92332364.0
3Display Results2622620.0634158.7
 (SQL Overall)1786912621.046170832.7
 
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.