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

162 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
needily116632(None) 
reedily1179601reedily
seedily1178581seedily
weedily1476121weedily
beadily1378842beadily
beefily1535612beefily
eerily92913562_eerily
greedily1345172greedily
headily1478622headily
leerily1037632leerily
needier84010622needier
needing93214422needing
needle73310612need_le
needy94614692need__y
nervily1336862nervily
readily11711402readily
reedify1465762reedify
speedily1465172speedily
weevily1694642weevily
aedile73716653_aedile
aerily93017013_aerily
agedly1136463aged_ly
bawdily1635803bawdily
beamily1477393beamily
beedi8711663beedi__
beedies10314203beedies
bodily12310993_bodily
breezily2243653breezily
cheekily2053473cheekily
cheerily1655423cheerily
cheesily1654413cheesily
credibly1644713credibly
creepily1574953creepily
dandily12279633dandily
deadly113811473dead_ly
deedier93011593deedier
deeding103315123deeding
deedy104315893deed__y
deeply1257013dee_ply
deerfly1443983deerfly
dewily1338343_dewily
dowdily1534953dowdily
easily9313023_easily
edgily1136063_edgily
edify12308563__edify
edile64819493__edile
eely77725213_ee__ly
feebly1436653fee_bly
feeding123515073feeding
fetidly1435013fetidly
fierily1339023fierily
fleecily1644013fleecily
gaudily1236523gaudily
gelidly1234743gelidly
gemmily1534603gemmily
giddily1335073giddily
handily143610873handily
hardily143310273hardily
heavily1665903heavily
heeding123515063heeding
heftily1635763heftily
heredity1546493heredity
inedibly1445903inedibly
jerkily2134623jerkily
keenly1336373kee_nly
leakily1436473leakily
lewdly1334393lewd_ly
meatily12311093meatily
medfly1535223_medfly
meekly1535193mee_kly
meetly1138673mee_tly
merrily1238633merrily
messily12298813messily
moodily1358203moodily
muddily1435963muddily
nakedly1534403naked_ly
nastily103011033nastily
nattily103610323nattily
nearly94813733n_early
neatly93812483n_eatly
nebuly1135793n_ebuly
neddies92710703neddies
neddy10479873n_ed_dy
need54934153need___
needed84114443need_ed
needer73614953need_er
needers84111903needers
needful1143863needful
needfully1642983needfully
needfuls1242403needfuls
neediest92611303neediest
needled9358513needled
needler8388893needler
needles83211563needles
needling10248753needling
needs65719633need__s
nelly84618813n_e_lly
nerdier83110353nerdier
nerdish1137103nerdish
nerdy95014703nerd__y
nettly9459453n_ettly
newly114610203n_e_wly
nidify1336763n_idify
niftily1335753niftily
nippily1444713nippily
nobbily1436693nobbily
noily86120993n__oily
noisily1038403noisily
nonoily1049543nonoily
nosily93712683n_osily
notedly1136883noted_ly
nudely10299033n_udely
nudity1037993n_udity
nuttily10308633nuttily
peppily1335123peppily
perkily1637803perkily
peskily1635083peskily
pettily1238173pettily
redly94217193_red_ly
reedier83815303reedier
reeding94124133reeding
reedit7617223reedi_t
reedits8511743reedits
reedy910020283reed__y
rowdily1436083rowdily
ruddily1236303ruddily
sedile73517233_sedile
seedier83513633seedier
seeding93719483seeding
seedy94821533seed__y
seely84522633see__ly
seemly1138433see_mly
sexily1638853_sexily
shadily1437723shadily
sleepily1344823sleepily
sneakily1544423sneakily
steadily1236213steadily
tardily11269583tardily
tearily10311153tearily
techily1537123techily
tepidly1334403tepidly
testily102910803testily
tidily102811393_tidily
trendily1256443trendily
uneasily1146453uneasily
unreadily1344343unreadily
untidily1245873untidily
vendibly17174473vendibly
verily122616053_verily
vexedly2143453vexed_ly
wearily1338783wearily
weedier113810623weedier
weeding123815213weeding
weedy125115003weed__y
weekly1635313wee_kly
weevil1295433weevil_
weevilly1782623weevilly
weevils1384683weevils
wheezily2642303wheezily
windily1437943windily
wordily1437853wordily
zestily19167563zestily

Search took 7 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 Limit1340271625.95322514.2
3Display Results1621620.0802025.0
 (SQL Overall)1786911626.18928872.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.