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

253 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
roar4632857(None) 
boar66134291boar
hoar76729161hoar
oar37057951_oar
rear45644551rear
road56332111road
roam67132411roam
roan47234201roan
roars55622241roars
soar46838671soar
afar76720782afar
agar58726412agar
ajar116217702ajar
alar46340072alar
ar211379382__ar
bar58070552_bar
bear66844642bear
boa56954032boa_
board85523002board
boars75229602boars
boart78835932boart
boas66150832boas
boat66360312boat
bolar75123472bolar
boor66130682boor
bora66141632bora
boyar106013762boyar
briar75718152briar
broad84817692broad
car59165562_car
char95132152char
coal66939252coal
coat67558352coat
coax136922982coax
coir66327242coir
cor59960942co_r
croak115216632croak
czar156013132czar
dear55343602dear
doat56947672doat
doer57734702doer
door56928512door
dor47253922do_r
dorr56627722dorr
dour56330432dour
drear65016902drear
ear36867882_ear
far67762602_far
fear75337792fear
fiar76427332fiar
foal76630922foal
foam97127172foam
for66952072fo_r
fora75937392fora
four76226862four
friar85414272friar
gar47259902_gar
gear55934972gear
gnar56021382gnar
goa47343802goa_
goad66830982goad
goal55829302goal
goas55239942goas
goat56250832goat
goer56827102goer
gor47848262go_r
groan65618422groan
groat65531972groat
guar56923292guar
haar77323492haar
hear76143882hear
hoard94918312hoard
hoars85925552hoars
hoary114516762hoary
hoax147718292hoax
hoer76533982hoer
hora76136562hora
hour75827312hour
izar136616012izar
jar107646152_jar
jowar155211432jowar
kbar106514652kbar
knar85818722knar
koa76737772koa_
koan85425032koan
koas85635092koas
kor76538892ko_r
kora86431552kora
kyar116916842kyar
lar37967532_lar
lear47045952lear
liar47229682liar
load56730602load
loaf76734902loaf
loam65630482loam
loan47436452loan
lobar7313012lobar
lour45430682lour
maar66025062maar
mar57965952_mar
moa57249182moa_
moan65832022moan
moas65545342moas
moat66352032moat
molar75223092molar
moor66628552moor
mor56855002mo_r
mora66641272mora
near45236502near
noir46722432noir
nor38048822no_r
oaf65952882_oaf
oak76238652_oak
oars46846032_oars
oat39888262_oat
or27354732_o_r
ora37250832ora_
orad56031692orad
oral47638122oral
orra46120722orra
osar46820952osar
our36042892_our
par57467022_par
pear69745232pear
polar75623452polar
poor65630222poor
pour611527472pour
proa66229962proa_
proas75028802proas
prowar114110942prowar
rad47662002r_ad
radar61316722radar
rag45761322r_ag
rah68052402r_ah
rai37658222r_ai
raj105740222r_aj
ram56867272r_am
ran38266622r_an
rap56261962r_ap
rare45348432r_are
ras37575392r_as
rat37892742r_at
raw67252252r_aw
rax108445722r_ax
ray66361992r_ay
read55942532read
real45750292real
ream65841612ream
reap65934742reap
rearm75923572rearm
rears54739652rears
rebar75420192rebar
ria36745502ria_
rial45938092rial
rias45540592rias
roach105717002roach
roads66523622roads
roamer84715162roamer
roams74919612roams
roans54926442roans
roared75015392roared
roarer63914332roarer
roast56230142roast
rob56754302ro_b
robe65335642robe
robs65837872robs
roc520243252ro_c
rock105735182rock
rocs65533662rocs
rod47953892ro_d
rode55844302rode
rods56442062rods
roe36861082ro_e
roes45954142roes
roger64521412roger
roil46235292roil
role45851822role
rolf75134872rolf
roll46331652roll
rom59855632ro_m
roman75424822roman
romp85926572romp
roms67038962roms
rood56733002rood
roof75738832roof
rook85532032rook
room66235082room
root45655922root
rope65542912rope
roper75431912roper
ropy96323412ropy
rosary92810352rosary
rose46148902rose
rosy76024872rosy
rot37282952ro_t
rota45834342rota
rotary92411302rotary
rotas54827722rotas
rote46249022rote
roti46332932roti
rotl45029682rotl
roto45935052roto
rotor55519732rotor
rots46454092rots
roue45941742roue
roup66627692roup
rout46153282rout
roux117419362roux
rove75136982rove
rover85527372rover
row67453672ro_w
rowan85418732rowan
rower85430492rower
rows75941752rows
royal85014702royal
ruer46127562ruer
rya67622012rya_
ryas77224612ryas
scar66434202scar
sear47353842sear
soak87227662soak
soap65831132soap
soars54732512soars
sofar86115492sofar
solar55927342solar
sonar56523422sonar
sora45746912sora
sour45935892sour
sowar85821342sowar
spar65433302spar
star48037762star
tar37570692_tar
tear45242882tear
toad55830182toad
tolar55524112tolar
tor39261682to_r
tora47545992tora
torr45630902torr
tour45530382tour
troak95213572troak
trocar848772trocar
tsar47819802tsar
tzar136315372tzar
uproar8106932uproar
var66148332_var
volar86917412volar
war67262422_war
wear75836722wear
woad85523942woad
yar67253832_yar
year76534252year
your78623432your
zoa128529992zoa_

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.280638182.1
2DLD Change Limit298722530.95331345.2
3Display Results2532530.0465500.0
 (SQL Overall)1786912531.279139711.5
 
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.