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

122 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
weirdly1427449(None) 
weirdy13395461weird_y
buirdly1334212buirdly
lairdly1134912lairdly
thirdly1444632thirdly
wearily1338782wearily
weird95111282weird__
weirded1234512weirded
weirder1144922weirder
weirdie11224062weirdie
weirdo10405882weird_o
weirdos11355122weirdos
weirds10478052weird_s
whirly15448862whir_ly
wildly13328122w_ildly
wirily123310782w_irily
acidly125211793aci_dly
acridly13396533acridly
aerily93017013ae_rily
airily93014823_airily
aridly105513703ari_dly
avidly13548783avi_dly
bairnly1234503bairnly
begirdle1253203begirdle
blindly1335743blindly
childly1644803childly
deadly113811473de_adly
dearly104615323dear_ly
deerfly1443983deerfly
diddly12389573_diddly
direly10311563_direly
early85324123_ear_ly
eerily92913563_eerily
fairly125610013fair_ly
ferly115517353fe_r_ly
fetidly1435013fetidly
fiddly14328483_fiddly
fierily1339023fierily
firmly1436663_firmly
gelidly1234743gelidly
girdle82110463_girdle
girly94415293_gir_ly
hardly135112833_hardly
heirdom1344493heirdom
idly85617323__i_dly
kindly14358843_kindly
leerily1037633leerily
lewdly1334393le_wdly
lordly1038753_lordly
luridly1196283luridly
merely111312583me_rely
merrily1238633merrily
mildly12318243_mildly
nearly94813733near_ly
nerdy95014703ne_rd_y
pearly116414843pear_ly
peartly1267453peartly
perdy115417323pe_rd_y
pertly115312543pe_rtly
piddly13319143_piddly
redly94217193re__dly
retiredly1343713retiredly
spindly13257383spindly
swirly12439253swir_ly
tearily10311153tearily
tepidly1334403tepidly
termly1138433te_rmly
tiddly11308783_tiddly
tiredly1136793_tiredly
twiddly15233773twiddly
twirly12427083twir_ly
veiledly1543143veiledly
verily122616053ve_rily
vexedly2143453vexedly
waddly14478723w_addly
warily122915093w_arily
warmly14228063w_armly
weakly1636483we_akly
weary115620613wear__y
weasely13317853weasely
wedgy13479793we__dgy
weedily1476123weedily
weedy125115003we_ed_y
weekday1841963weekday
weekly1635313we_ekly
weevily1694643weevily
weigela1143073weigela
weighty17376233weighty
weir76019923weir___
weirdest1244433weirdest
weirdies12255783weirdies
weirding1335593weirding
weirdoes12323833weirdoes
weirs84316493weir__s
welly114620013we__lly
wetly114511713we__tly
whirl114913823whir_l_
whirls124710533whir_ls
whirry15477063whir_ry
whitely16346473whitely
widdle113814843w_iddle
widdy136112183w_i_ddy
widely133311033w_idely
wieldy13476183wield_y
wifely15429423w_ifely
wiggly14559683w_iggly
wilily123310763w_ilily
willy115321913w_i_lly
wily106428813w_i__ly
windily1437943w_indily
windle104617953w_indle
windy126118103w_ind_y
wiry106422833w_ir__y
wisely122711713w_isely
wizardly2452573wizardly
wordily1437853w_ordily
wordy126916163w_ord_y
worldly1433983worldly
wriggly15324893wriggly
wrinkly17295753wrinkly
wryly14356703w__ryly
yearly125210273year_ly

Search took 8 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 Filter1786911340270.1561145455.1
2DLD Change Limit1340271226.89019452.4
3Display Results1221220.0333697.0
 (SQL Overall)1786911227.07925242.4
 
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.