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 “waffly” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

279 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
waffly1830543(None) 
waffle15369181waffle
baffle14399872baffle
baffy165511922baff_y
barfly14339652barfly
daffily1735132daffily
daffy155510282daff_y
daftly1335442daftly
dayfly1633812dayfly
gadfly1434662gadfly
mayfly1734402mayfly
raffle123910702raffle
ruffly15336672ruffly
safely12249392safely
sawfly1535132sawfly
taffy145110822taff_y
wabbly16348362wabbly
waddly14478722waddly
wafery15398692wafery
waff134228042waff__
waffed16459792waffed
waffie15338562waffie
waffled17357522waffled
waffler16377782waffler
waffles16329982waffles
waffs146315472waff_s
waggly14347292waggly
wally114625092wa_lly
waly105830902wa__ly
wambly16388662wambly
wanly115118022wa_nly
warily122915092warily
warmly14228062warmly
wavily15219482wavily
waxily19218412waxily
wifely15429422wifely
ably99725133_a_bly
aff95537613_aff__
affably1855183_affably
affix1836003_affix
afflux1942793_afflux
affray1534973_affray
agly86821803_a_gly
ally76935643_a_lly
amply125012913_amply
apply125111393_apply
aptly105111813_aptly
awful1178143awful_
awfully1644003awfully
badly114918763ba_dly
baff124632263baff__
baffed154812173baffed
baffled16418063baffled
baffler15418113baffler
baffles153710683baffles
baffs134718053baff_s
baldly12479833baldly
bally105530103ba_lly
barely114716793barely
basely114412313basely
bassly114610073bassly
biffy164711123biff_y
bluffly1833433bluffly
botfly1436093botfly
buffy165013373buff_y
caff125631673caff__
caffs135417373caff_s
cagily12411563cagily
calmly1337613calmly
chaffy20456473chaff_y
coffle14359043coffle
daff115229683daff__
daffed14429493daffed
daffs125116423daff_s
daily95922333da_ily
dally95324743da_lly
damply14337893damply
dangly114212263dangly
dankly14419463dankly
darkly145411073darkly
deafly13389123deafly
deftly1336533deftly
draffy16486633draff_y
duffle13368533duffle
early85324123ea_rly
easily9313023easily
fairly125610013fairly
family143311703family
fatly115716803fa_tly
fly97124953___fly
gaff114828153gaff__
gaffe124111653gaff_e
gaffed144210203gaffed
gaffer134310133gaffer
gaffes134811103gaffes
gaffs124914653gaff_s
gaily95020973ga_ily
gainly1049323gainly
gallfly1433523gallfly
gally95026173ga_lly
gamely124711913gamely
gamily123712183gamily
gangly113911583gangly
gayly124513093ga_yly
gruffly17413893gruffly
hackly18298733hackly
haffet15311703haffet
haffit1538533haffit
haply135915063ha_ply
hardly135112833hardly
hazily2179063hazily
huffily1934693huffily
huffy174810233huff_y
iffy135312283_iff_y
jangly174310603jangly
jiffy21458313jiff_y
kaffir16345303kaffir
lacily11612763lacily
lamely114013223lamely
lanely93914483lanely
lankly13439623lankly
lastly93310873lastly
lately93413843lately
laxly15610103la_xly
lazily1859713lazily
liefly1266363liefly
madly115218133ma_dly
maffia14327203maffia
mainly11411493mainly
manly105022943ma_nly
marbly134111933marbly
marly106925613ma_rly
mazily20610393mazily
medfly1535223medfly
miffy163910193miff_y
muffle14339643muffle
naff105128933naff__
naffed13408333naffed
naffs116213963naff_s
namely113711323namely
outfly1238273outfly
packly17228333packly
palely11311923palely
pally105727123pa_lly
paly95835533pa__ly
panfry14456413panfry
partly116315473partly
patly105020583pa_tly
piffle14418233piffle
puffily1834843puffily
puffy164410753puff_y
racily11715173racily
raff104933043raff__
raffia12287703raffia
raffled14429083raffled
raffler13339223raffler
raffles133611843raffles
raffs115017523raff_s
rally84725903ra_lly
rankly133910453rankly
raptly11338913raptly
rarely93513653rarely
rashly123410213rashly
rattly94111543rattly
rawly115115833ra_wly
refly113914563_refly
rifely123710033rifely
riffle124210233riffle
ruffle124111673ruffle
sadly94519123sa_dly
safety12206913safety
sagely102811383sagely
sally85129713sa_lly
sandfly1435643sandfly
sanely93114613sanely
shadfly1733783shadfly
snaffle13216243snaffle
sniffly16265643sniffly
snuffly16305193snuffly
softly12457763softly
stiffly16235173stiffly
swiftly1633733swiftly
taffia12286903taffia
tally84526863ta_lly
tamely113711953tamely
tangly104413913tangly
tartly96014023tartly
tautly9499503tautly
toffy145310283toff_y
vainly1258503vainly
vastly12508723vastly
wabble133714843wabble
wackily1936053wackily
wacky174714933wa_cky
waddle114715303waddle
waddy135312993wa_ddy
wady115324993wa__dy
waeful1238123waeful
wafer114417643wa_fer
wafers124316143wafers
waffies163611443waffies
waffing173710243waffing
wafflers17306323wafflers
wafflier1733953wafflier
waffling1845423waffling
waft106139003wa_f_t
wafted134012143wafted
wafter124114613wafter
wafts116920553wa_fts
waggle113612303waggle
waif105836743waif__
waifed134011033waifed
waifs115719873waif_s
wail75238823wa_il_
wails86631483wa_ils
wale74546433wa__le
walk115625613wa__lk
wall76236103wa__ll
walla85321033wa_lla
walls85529383wa_lls
wamble134415753wamble
wandle105316663wandle
waney115120323wa_ney
wangle103817503wangle
wany106432353wa__ny
warble113516603warble
warsle93112923warsle
warty119323823wa_rty
wary106740013wa__ry
washy145911843wa_shy
waspily1535513waspily
waspy135410993wa_spy
wastry12388773wastry
watery123914493watery
wattle94314213wattle
waul76927313wa_ul_
wauls86120553wa_uls
wavery154610053wavery
wavey145115543wa_vey
wavy136620473wa__vy
wawl105321943wa_wl_
wawls115416473wa_wls
waxy175918203wa__xy
way96757663wa___y
waylay1535453waylay
weakly1636483weakly
wearily1338783wearily
weasely13317853weasely
weekly1635313weekly
welly114620013w_elly
wetly114511713w_etly
whiffle1933533whiffle
whirly15448863whirly
wholly15366573wholly
widely133311033widely
wifey144913673w_ifey
wifty144212093w_ifty
wiggly14559683wiggly
wildly13328123wildly
wilily123310763wilily
willy115321913w_illy
wily106428813w__ily
wirily123310783wirily
wisely122711713wisely
wobbly16347093wobbly
woful1158173woful_
wofully1644523wofully
woolly12408513woolly
wooly114417673w_ooly
wryly14356703w_ryly
yaff135324263yaff__
yaffed16457323yaffed
yaffs145311123yaff_s
yarely122810303yarely
zaffar21385043zaffar
zaffer21397153zaffer
zaffir21395513zaffir
zaffre21354663zaffre
zanily18310183zanily

Search took 9 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 Filter1786911127160.406440125.6
2DLD Change Limit1127162797.62614780.5
3Display Results2792790.0933000.0
 (SQL Overall)1786912798.12521992.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.