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

116 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
awny10591930(None) 
any68440491a_ny
away108024221away
awn68035911awn_
awns75324431awns
awry107619681awry
fawny144711711fawny
lawny115912011lawny
tawny114713651tawny
wany106432361wany
ably99725132ably
aby810238062a_by
achy126316092achy
acne66625872acne
aery77231682aery
agly86821802agly
agony96415652agony
ahoy101919182ahoy
ain37579092ain_
ains46158882ains
airy75734152airy
alky115920342alky
ally76935642ally
alway116113922alway
an211879082a_n_
ana39559832a_na
and47244172a_nd
ane37866952a_ne
ani37751182a_ni
anna45529012anna
annoy869712annoy
ant37270792a_nt
army96624182army
arty77531312arty
ashy107717352ashy
atony87218852atony
aunt46553652aunt
aunty85919812aunty
aw512563402aw__
awa611939672aw_a
awe67746622aw_e
awed88436032awed
awee76336642awee
awes76037552awes
awing96827322awing
awl67635302aw_l
awls75926092awls
awned96615952awned
awol75620672awol
ay511773892a__y
barny105821732barny
bawdy147513282bawdy
bawty135614102bawty
bony96732082bony
brawny144710602brawny
canny105817692canny
carny105822922carny
cony96537832cony
dawn85624202dawn_
dawns95916592dawns
deny86027122deny
downy125714552downy
fanny114816042fanny
fawn105321952fawn_
fawns115914262fawns
gawky16569992gawky
gawsy12459092gawsy
lawn75925632lawn_
lawns85215422lawns
liny78141322liny
luny77324132luny
many95731862many
mawn94424142mawn_
mony96830012mony
nanny84813812nanny
own66429702own_
owns76819582owns
pawky173810152pawky
pawn94625302pawn_
pawns108818132pawns
piny911838352piny
pony96434052pony
puny95526992puny
rainy85921082rainy
rawly115115832rawly
sawn75428162sawn_
sawney12387602sawney
sway107128232sway
tawney12338232tawney
tiny76134632tiny
tony75635152tony
towny116114492towny
twiny116012812twiny
viny106025952viny
wady115324992wady
waly105830902waly
wan66761942wan_
wand85833882wand
wane76344722wane
waney115120322waney
wank115632512wank
wanly115118022wanly
wans76452272wans
want76156172want
wary106740012wary
wavy136620472wavy
waxy175918202waxy
way96757662_way
why126920012_why
winy107034322winy
wry96524702_wry
wyn95921442_wyn
yawey14458272yawey
yawn106219092yawn_
yawns114213272yawns
zany167316992zany

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.266671770.7
2DLD Change Limit298721160.86034734.9
3Display Results1161160.0303866.7
 (SQL Overall)1786911161.156154577.0
 
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.