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

219 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
dayfly163381(None) 
mayfly1734401mayfly
barfly14339652barfly
daffily1735132daffily
daffy155510282da_ffy
daftly1335442daftly
daily95922332da_ily
dally95324742da_lly
damply14337892damply
dangly114212262dangly
dankly14419462dankly
darkly145411072darkly
daylily1434982daylily
deafly13389122deafly
doyly124514012doy_ly
dryly12538452dry_ly
gadfly1434662gadfly
gayly124513092gay_ly
sawfly1535132sawfly
waffly18305432waffly
ably99725133_a_bly
agly86821803_a_gly
ally76935643_a_lly
amply125012913_amply
apply125111393_apply
aptly105111813_aptly
badly114918763ba_dly
baffle14399873baffle
baffy165511923ba_ffy
baldly12479833baldly
bally105530103ba_lly
barely114716793barely
basely114412313basely
bassly114610073bassly
botfly1436093botfly
cagily12411563cagily
calmly1337613calmly
coyly135614893coy_ly
dabble114515193dabble
dactyl1234983dactyl
daddle94214283daddle
daddy116212563da_ddy
daff115229683da_f_f
daffed14429493daffed
daffs125116423da_ffs
daft85537253da_f_t
daggle93711903daggle
dahl87019223da_hl_
dahls95012283da_hls
dainty105311473dainty
dairy97016303da_iry
daisy95915313da_isy
dal47554953da__l_
dale55643983da__le
dals57145123da__ls
dandily12279633dandily
dandle84218093dandle
dandy104416703da_ndy
dangle84119303dangle
dapple1138853dapple
darkey145212423darkey
darkle113813943darkle
darky136018833da_rky
dartle73714833dartle
dashy125612383da_shy
datary10310243datary
datedly1236023datedly
daubry12445483daubry
dauby115211223da_uby
davy116015523da__vy
dawdle11399503dawdle
day76254113da___y
daybed13438673daybed
dayflies1534463dayflies
dayglow1541843dayglow
daylit10512493daylit
days87637133day__s
dazedly2134063dazedly
dazzle1536853dazzle
deadly113811473deadly
dearly104615323dearly
deathly14336863deathly
deeply1257013deeply
deerfly1443983deerfly
deftly1336533deftly
defy114921263d_ef_y
deify124112763deif_y
delly96023873d_elly
dewily1338343dewily
dhooly13457143dhooly
dicycly1843273dicycly
diddly12389573diddly
dilly94923783d_illy
dimly114913483d_imly
dimply14339743dimply
dinkly144311083dinkly
direly10311563direly
doily95321033d_oily
dolly96125203d_olly
dooly94821803d_ooly
dopily123510463dopily
doubly12328963doubly
dourly103210433dourly
doyley13487283doyley
dozily19329103dozily
drably123511613drably
draffy16486633draffy
drafty13638933drafty
drawly134910723drawly
drifty13418223drifty
drily95816523d_rily
drolly105411673drolly
drooly104911073drooly
drumly1235703drumly
dually103210063dually
duffle13368533duffle
dully94921633d_ully
duly85323033d__uly
dumbly14399603dumbly
dyable12308983dyable
dykey16608673d_ykey
early85324123ea_rly
easily9313023easily
fairly125610013fairly
family143311703family
fatly115716803fa_tly
feyly14429513fey_ly
fly97124953___fly
gaily95020973ga_ily
gainly1049323gainly
gallfly1433523gallfly
gally95026173ga_lly
gamely124711913gamely
gamily123712183gamily
gangly113911583gangly
gayal9312713gayal_
gayals1039513gayals
gayety13116383gayety
grayly13287963gray_ly
hackly18298733hackly
haply135915063ha_ply
hardly135112833hardly
hayey144812533hay_ey
hazily2179063hazily
jangly174310603jangly
lacily11612763lacily
lamely114013223lamely
lanely93914483lanely
lankly13439623lankly
lastly93310873lastly
lately93413843lately
laxly15610103la_xly
lazily1859713lazily
liefly1266363liefly
madly115218133ma_dly
mainly11411493mainly
manly105022953ma_nly
marbly134111933marbly
marly106925613ma_rly
mayday1535883mayday
mazily20610393mazily
medfly1535223medfly
namely113711323namely
naysay1234973naysay
outfly1238273outfly
packly17228333packly
palely11311933palely
pally105727123pa_lly
paly95835533pa__ly
panfry14456413panfry
partly116315473partly
patly105020583pa_tly
payably17177093payably
payday1536613payday
payola11208113payola
racily11715173racily
raffle123910703raffle
rally84725903ra_lly
rankly133910453rankly
raptly11338913raptly
rarely93513653rarely
rashly123410213rashly
rattly94111543rattly
rawly115115833ra_wly
refly113914563_refly
ruffly15336673ruffly
sadly94519123sa_dly
safely12249393safely
sagely102811383sagely
sally85129713sa_lly
sandfly1435643sandfly
sanely93114613sanely
shadfly1733783shadfly
shyly144811573shy_ly
slyly11489533sly_ly
taffy145110823ta_ffy
tally84526863ta_lly
tamely113711953tamely
tangly104413913tangly
tartly96014023tartly
tautly9499503tautly
vainly1258503vainly
vastly12508723vastly
wabbly16348363wabbly
waddly14478723waddly
waffle15369183waffle
waggly14347293waggly
wally114625093wa_lly
waly105830903wa__ly
wambly16388663wambly
wanly115118023wa_nly
warily122915093warily
warmly14228063warmly
wavily15219483wavily
waxily19218413waxily
waylay1535453waylay
wryly14356703wry_ly
yarely122810303yarely
zanily18310183zanily

Search took 6 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.373479064.3
2DLD Change Limit1127162195.47020606.2
3Display Results2192190.0633476.2
 (SQL Overall)1786912195.90630255.8
 
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.