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

272 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
gadfly143466(None) 
badly114918762bad_ly
barfly14339652barfly
dayfly1633812dayfly
gaily95020972ga_ily
gainly1049322gainly
gallfly1433522gallfly
gally95026172ga_lly
gamely124711912gamely
gamily123712182gamily
gangly113911592gangly
gaudily1236522gaudily
gayly124513092ga_yly
gladly11497932glad_ly
godly104913292god_ly
madly115218132mad_ly
mayfly1734402mayfly
medfly1535222medfly
sadly94519122sad_ly
sandfly1435642sandfly
sawfly1535132sawfly
shadfly1733782shadfly
waddly14478722waddly
waffly18305432waffly
ably99725133_a_bly
addle74318353_addle
adult63520653_adult
agedly1136463agedly
agly86821803_a_gly
ally76935643_a_lly
amply125012913_amply
apply125111393_apply
aptly105111813_aptly
baddy125016023bad_dy
baffle14399873baffle
baffy165511923ba_ffy
baldly12479833baldly
bally105530103ba_lly
barely114716793barely
basely114412313basely
bassly114610073bassly
bawdily1635803bawdily
beadily1378843beadily
bodily12310993bodily
botfly1436093botfly
caddy125414023cad_dy
cadgy125210783cad_gy
cagily12411563cagily
calmly1337613calmly
cuddly13388413cuddly
daddle94214283daddle
daddy116212563dad_dy
daffily1735133daffily
daffy155510283da_ffy
daftly1335443daftly
daily95922333da_ily
dally95324743da_lly
damply14337893damply
dandily12279633dandily
dangly114212273dangly
dankly14419463dankly
darkly145411073darkly
deadly113811473dead_ly
deafly13389123deafly
diddly12389573diddly
duly85323033__duly
early85324123ea_rly
easily9313023easily
faddy135511623fad_dy
fadedly1535453fadedly
fairly125610013fairly
family143311703family
fatly115716803fa_tly
fiddly14328483fiddly
fly97124953___fly
gabble113815723gabble
gabby135512953ga_bby
gable85325523ga_ble
gaby107123193ga__by
gad57556653gad___
gadded103913173gadded
gadder93714713gadder
gaddi85211633gad_di
gaddis94211373gaddis
gadflies1334733gadflies
gadget93616183gadget
gadgety13356163gadgety
gadi66329723gad__i
gadid85517383gad_id
gadids95611823gadids
gadis74825293gad_is
gadje1457743gad_je
gadjo1436913gad_jo
gadoid9310463gadoid
gads67843383gad__s
gadwall1244563gadwall
gaff114828153ga_f_f
gaffe124111653ga_ffe
gaffed144210203gaffed
gaffer134310133gaffer
gaffes134811103gaffes
gaffs124914653ga_ffs
gaggle93412623gaggle
gaiety10119373gaiety
gal46055513ga__l_
gala55635163ga__la
galaxy17476313galaxy
gale56347323ga__le
gall56335993ga__ll
galley104215453galley
galls64729323ga_lls
gals57946503ga__ls
gamay116419113ga_may
gamble115417183gamble
gamey115320553ga_mey
gammy135514893ga_mmy
gamy105427533ga__my
gantry103810113gantry
gaol56925413ga_ol_
gaols66717573ga_ols
gappy136212033ga_ppy
gapy106320913ga__py
garble94118453garble
gargle84215463gargle
garvey13127873garvey
gasify1336333gasify
gassily1137813gassily
gassy95514023ga_ssy
gaudery1234743gaudery
gaudy106611463ga_udy
gault65128483ga_ult
gauntly1135333gauntly
gauzily2034393gauzily
gauzy18489213ga_uzy
gavel95815183gavel_
gavels105911093gavels
gawkily1834093gawkily
gawky16569993ga_wky
gawsy12459093ga_wsy
gay76856493ga___y
gayal9312713gayal_
gayals1039513gayals
gayety13116383gayety
gently103710913gently
ghastly14354563ghastly
giddily1335073giddily
giddy115810203gid_dy
giggly12518703giggly
gilly94321633g_illy
girly94415293g_irly
glady105413943glad__y
glazily2035383glazily
glegly1134873glegly
glibly1236293glibly
glowfly1742673glowfly
gluily10308293gluily
glumly12356623glumly
gnarly104610383gnarly
godlily1235343godlily
goggly12337053goggly
golly95121103g_olly
goodly11419303goodly
goofily14105353goofily
goofy124915623goof_y
googly11417883googly
gorily10612503gorily
grandly1238743grandly
gravely14469063gravely
grayly13287963grayly
greyly13316543greyly
grimly12459933grimly
grisly104310583grisly
growly13499173growly
gruffly17413893gruffly
gruffy16396013gruffy
gulfy124612003gulf_y
gully94020683g_ully
hackly18298733hackly
hadal95518123hadal_
handily143610873handily
haply135915063ha_ply
hardily143310273hardily
hardly135112833hardly
hazily2179063hazily
headily1478623headily
idly85617323_id_ly
jadedly1934013jadedly
jangly174310613jangly
lacily11612763lacily
ladle66320443lad_le
lady86527153lad__y
lamely114013223lamely
lanely93914483lanely
lankly13439623lankly
lastly93310873lastly
lately93413843lately
laxly15610103la_xly
lazily1859713lazily
liefly1266363liefly
mainly11411493mainly
manly105022953ma_nly
marbly134111933marbly
marly106925613ma_rly
mazily20610393mazily
muddly13418603muddly
namely113711323namely
nudely10299033nudely
oddly1037163_oddly
outfly1238273outfly
packly17228333packly
paddle104615143paddle
paddy125913593pad_dy
padle84522343pad_le
palely11311933palely
pally105727123pa_lly
paly95835533pa__ly
panfry14456413panfry
partly116315473partly
patly105020583pa_tly
piddly13319143piddly
puddly13438133puddly
racily11715173racily
raddle84816173raddle
radula749313radula
raffle123910703raffle
rally84725903ra_lly
rankly133910453rankly
raptly11338913raptly
rarely93513653rarely
rashly123410213rashly
rattly94111543rattly
rawly115115833ra_wly
readily11711403readily
redly94217203red_ly
refly113914563_refly
rudely10389973rudely
ruffly15336673ruffly
saddle83915493saddle
safely12249393safely
sagely102811383sagely
sally85129713sa_lly
sanely93114613sanely
shadily1437723shadily
taffy145110823ta_ffy
tally84526863ta_lly
tamely113711953tamely
tangly104413933tangly
tardily11269583tardily
tartly96014023tartly
tautly9499503tautly
tiddly11308783tiddly
tidily102811393tidily
unduly1037823unduly
vainly1258503vainly
vastly12508723vastly
wabbly16348363wabbly
waddle114715303waddle
waddy135312993wad_dy
wady115324993wad__y
waffle15369183waffle
waggly14347293waggly
wally114625093wa_lly
waly105830903wa__ly
wambly16388663wambly
wanly115118023wa_nly
warily122915093warily
warmly14228063warmly
wavily15219483wavily
waxily19218413waxily
widely133311033widely
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.376475242.0
2DLD Change Limit1127162724.75023729.7
3Display Results2722720.0932924.7
 (SQL Overall)1786912725.21934238.6
 
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.