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

157 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
away10802422(None) 
alway116113921alway
awa611939671awa_
awny105919301awny
awry107619681awry
sway107128231sway
way96757661_way
aa219179952a_a_
aah616252962a_ah
aal39058672a_al
aas310975392a_as
aba512850952aba_
abas68642082abas
abaya104413172abaya
ably99725132ably
aby810238062a_by
achy126316092achy
aery77231682aery
afar76720782afar
aga410447232aga_
agar58726412agar
agas55938842agas
agly86821802agly
aha611246642aha_
ahoy101919182ahoy
airway1237692airway
airy75734152airy
ajar116217702ajar
ala312463602ala_
alae45643752alae
alan46844082alan
alar46340072alar
alary86123442alary
alas46358122alas
alky115920342alky
allay85620392allay
ally76935642ally
always12409132always
ama510853302ama_
amah98927482amah
amas67746292amas
ana39559822ana_
anal48037522anal
anas46649862anas
any68440482a_ny
anyway1534802anyway
arak86929572arak
army96624182army
array86317142array
arty77531312arty
ashy107717352ashy
assay8710282assay
atap66722452atap
ataxy1537312ataxy
ava610139322ava_
aw512563402aw__
await85524492await
awake125014782awake
award97118042award
aware86420022aware
awash116613162awash
awe67746622aw_e
aweary1237302aweary
awed88436032awed
awee76336642awee
awes76037552awes
awl67635302aw_l
awls75926092awls
awn68035912aw_n
awns75324432awns
awol75620672awol
axal116520492axal
ay511773892__ay
ayah108022992ayah
azan136521782azan
bawdy147513282bawdy
bawty135614102bawty
bay89661642_bay
bray95232902bray
byway1647532byway
cay87155982_cay
chay124924872chay
clay95927412clay
day76254112_day
dray85428092dray
fawny144711712fawny
fay97454862_fay
flay106332802flay
fray105428902fray
gamay116419102gamay
gawky16569992gawky
gawsy12459092gawsy
gay76856492_gay
gray85329892gray
hay97358772_hay
hwan105716892hwan
jawan15710382jawan
jay136242672_jay
kay106745542_kay
lawny115912012lawny
lay68865352_lay
may88757622_may
nawab10810922nawab
nay66952772_nay
noway111112842noway
ofay106416102ofay
okay115917662okay
pawky173810152pawky
pay88461182_pay
play95928982play
pray96331532pray
quay164618352quay
rawly115115832rawly
ray66361992_ray
satay84718462satay
say67264762_say
seaway12309992seaway
shay107133342shay
slay76436382slay
spay96631662spay
stay78333722stay
swab96825312swab
swag87526732swag
swam96329982swam
swamy136714402swamy
swan76631312swan
swap95925432swap
swat77244442swat
sways115518462sways
tawny114713652tawny
tray77632592tray
twa67721642twa_
twae74719572twae
twas76824082twas
twat75831512twat
wab87051832_wab
wad77053892_wad
wady115324992wady
wae67556952_wae
wag76451752_wag
waly105830902waly
wan66761932_wan
wany106432352wany
wap86553372_wap
war67262422_war
wary106740012wary
was68767562_was
wat67378922_wat
wavy136620472wavy
waw97046382_waw
wax137041182_wax
waxy175918202waxy
ways107737952_ways
why126920012_why
wry96524702_wry
yawey14458272yawey
yay96948712_yay

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 Limit298721571.01629401.6
3Display Results1571570.0334757.6
 (SQL Overall)1786911571.109161128.0
 
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.