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

249 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
roans5492644(None) 
groans74815061groans
koans95818621koans
loans56026461loans
moans74624371moans
roads66523621roads
roams74919611roams
roan47234201roan_
roars55622241roars
romans84620241romans
rowans95715341rowans
alans55636172alans
azans146516882azans
bans66555142_bans
beans75734692beans
boars75229602boars
boas66150832boa_s
boats75635152boats
bogans95714812bogans
boons75031912boons
brans75437432brans
broads94515152broads
brogans1049662brogans
browns116415632browns
cans65050852_cans
clans75031012clans
coals76129602coals
coats75635002coats
coins75834552coins
conns75024232conns
cons66057692co_ns
coons76737282coons
corns76034762corns
cotans81317922cotans
croaks125812982croaks
croons85418422croons
crowns115615112crowns
cyans105714812cyans
dans56748152_dans
deans66131392deans
doats65224882doats
donas65926472donas
dons56048702do_ns
downs94918572downs
drowns105612332drowns
elans55527752elans
eons46638712eo_ns
fans76247372_fans
flans85327972flans
foals85721692foals
foams105017952foams
fohns117310782fohns
foins85523382foins
fons76943892fo_ns
frons86124042fro_ns
frowns126011392frowns
glans65125832glans
goads77022852goads
goals65521292goals
goas55239942goa_s
goats65527302goats
gobans94412042gobans
goons65326772goons
gowans105512292gowans
gowns95115102gowns
grans64832542grans
groan65618422groan_
groats74816652groats
groins73917202groins
guans64419442guans
hoars85925552hoars
hogans105914312hogans
honans94814502honans
hons77350782ho_ns
horns86125332horns
ions46737852io_ns
irons55324132iro_ns
jeans126022112jeans
johns15398712johns
joins125818412joins
kaons95014852kaons
khans124615172khans
koan85425032koan_
koas85635092koa_s
kroons103711242kroons
leans55536252leans
loads65323372loads
loafs85616992loafs
loams75619862loams
loan47436452loan_
logans76319062logans
loins56728422loins
loons55731722loons
lorans65117602lorans
mans66354552_mans
means75831232means
moan65832022moan_
moas65545342moa_s
moats75827642moats
monas74732152monas
mons68152262mo_ns
moons75331002moons
morns75527442morns
naans55815252naans
nans46139402_nans
nonas55126652nonas
noons54125282noons
nouns56717312nouns
oafs76425262_oafs
oaks86527902_oaks
oars46846032_oars
oats46554212_oats
ons36148512_o_ns
orals55826482orals
orang65119942orang
orangs74116032orangs
organs7912912organs
owns76819582_owns
pans65855732_pans
peans75437642peans
pians75126962pians
plans75731272plans
pons65850602po_ns
poons75430972poons
porns75527342porns
proas75028802proa_s
prolans9314272prolans
rads56046602r_ads
rags55448372r_ags
rains55140232rains
rais45252622r_ais
rams65950772r_ams
ran38266622r_an_
rand55839572r_and
rands65930452r_ands
rang56939162r_ang
rani46640112r_ani
ranis55235832r_anis
rank85135532r_ank
ranks95225732r_anks
rant45864682r_ant
rants55935342r_ants
raps66247732r_aps
ras37575392r_a_s
ratans63819372ratans
rats46260372r_ats
raws75238212r_aws
rays77642352r_ays
reads64835272reads
reals55038652reals
reams75729622reams
reaps75626192reaps
rears54739652rears
redans75421022redans
reins56234562reins
reloans7313132reloans
remans84823002remans
rials55026672rials
riant55833152riant
rias45540592ria_s
rins46153192r_ins
roach105717002roach
road56332112roa_d
roam67132412roa_m
roar46328572roa_r
roast56230142roast
roasts64915412roasts
roband92310722roband
robands10219862robands
robes75133302robes
robins83617452robins
robs65837872ro_bs
rocks114626412rocks
rocs65533662ro_cs
rodes614039082rodes
rods56442062ro_ds
roes45954142ro_es
roils54826792roils
roles56747982roles
rolfs84817122rolfs
rolls55326232rolls
roman75424822roman_
romano84912942romano
romanos94311482romanos
romps94617542romps
roms67038962ro_ms
roods65125282roods
roofs85321152roofs
rooks95325042rooks
rooms75324682rooms
roots55933672roots
ropes75940062ropes
roses56445772roses
rosins64521862rosins
rotas54827722rotas
rotes56143902rotes
rotis56327062rotis
rotls55620162rotls
rotos56027882rotos
rots46454092ro_ts
rouens64814442rouens
roues56039352roues
round64318432round
rounds73615622rounds
roups75118902roups
routs57133412routs
roves84834482roves
rowan85418732rowan_
rowens94515302rowens
rows75941752ro_ws
royals93711262royals
ruana5312422ruana
ruanas6311262ruanas
ruins55822032ruins
runs46438072r_uns
ryas77224612rya_s
ryokans1443292ryokans
sans45153362_sans
scans74625102scans
soaks95220292soaks
soaps75120712soaps
soars54732512soars
solans64122492solans
somans84619302somans
sons46049552so_ns
sorns55028422sorns
sowans94215892sowans
spans74528732spans
swans84625012swans
tans46154822_tans
toads65621072toads
tolans64319272tolans
tomans85419132tomans
tons46553052to_ns
toons55027532toons
towns86018882towns
trans54933042trans
troaks104410602troaks
tronas63816902tronas
ulans54921302ulans
vans76236732_vans
wans76452272_wans
weans85326742weans
woads94818442woads
womans114613652womans
wons74942042wo_ns
yeans86624882yeans
yuans84613322yuans
zoons144919692zoons

Search took 8 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 Filter178691538000.843211970.3
2DLD Change Limit538002496.0638873.5
3Display Results2492490.280889.3
 (SQL Overall)1786912497.18624866.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.