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

133 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
brainily133731(None) 
brawnily1644081brawnily
rainily10310431_rainily
bracingly1745942bracingly
brainiac1245632brainiac
brainier102510232brainier
braining113414682braining
brainish1338812brainish
brainy114815642brain__y
brassily1336622brassily
airily93014823__airily
baggily1436043b_aggily
bairnly1234503b_airnly
balkily16266693b_alkily
balmily14216463b_almily
bawdily1635803b_awdily
beadily1378843bea_dily
beamily1477393bea_mily
beamingly1745843beamingly
bitingly1437383bitingly
blandly1336043bla_ndly
blankly1634263bla_nkly
blazingly2444473blazingly
blindly1335743b_lindly
bodingly1536383bodingly
bonnily1236873b_onnily
boringly1438403boringly
bovinely1664423bovinely
bovinity1645023bovinity
bowingly1735793bowingly
braiding123112703braiding
brail75525553bra__il_
brailing113514793brailing
braille939713brai_lle
brails84621293bra__ils
brain76229383brain___
brainchild1851973brainchild
brained103816103brain_ed
brainiacs1343773brainiacs
brainiest11209723brainiest
brainpan1243673brainpan
brains85125473brain__s
brainsick1742643brainsick
brainsickly226603brainsickly
braising113014563braising
brambly16296253bra_mbly
branchy17357913bra_nchy
brandy124712063bra_n_dy
brannier10218933brannier
branning112911093branning
branny115111833bra_n_ny
brashly15427613bra_shly
brasil8713863bra_sil_
brasils9410973bra_sils
braunite1047253braunite
bravely15428233bra_vely
brawly144312353bra__wly
brawnier13216723brawnier
brawny144710603brawn__y
brazenly2263833brazenly
brazil1779623bra_zil_
brazils1867753bra_zils
breathily1744063breathily
breezily2243653breezily
briefly1534573br_iefly
brindle104210103br_indle
brinier93613473br_inier
brinies93317913br_inies
brining103216473br_ining
brinish1239963br_inish
briny104719663br_in__y
briskly16165403br_iskly
bristly12178063br_istly
brittly12165973br_ittly
broodily1445503broodily
burningly1545043burningly
cannily1239263_cannily
crabbily1744343crabbily
craftily1644783craftily
craggily1543703craggily
crankily1755623crankily
crankly16358123cra_nkly
crazily2136923cra_zily
crinkly16387523cr_inkly
cryingly1735743cryingly
daintily1245523_daintily
daringly1348573daringly
draftily1534413draftily
draining103312673draining
erringly1237773erringly
faintly1337083_faintly
frailly1337313frai_lly
frankly17315633fra_nkly
fruitily1445143fruitily
gainly1049323_gain_ly
grainier9218903grainier
graining102813183graining
grainy103914213grain__y
grandly1238743gra_ndly
grassily1236433grassily
gratingly1437393gratingly
grazingly2344943grazingly
grimily1336523gr_imily
mainly11411493_main_ly
plainly1236473plain_ly
pratingly1538363pratingly
pricily142710283pr_icily
privily15207623pr_ivily
pryingly1735543pryingly
quaintly2065023quaintly
racily11715173_ra_cily
ragingly1337863_ragingly
rainier71614263_rainier
raining83922693_raining
rainy85921083_rain__y
raisiny10319923_raisiny
rankly133910453_ra_nkly
ravingly1537293_ravingly
riantly1037613_riantly
saintly1039343_saintly
shinily13268933_shinily
tawnily1335443_tawnily
tinily94014433__tinily
training93015863training
trainway1444223trainway
trashily1437323trashily
trinity10310843tr_inity
tryingly1535883tryingly
urgingly1336733urgingly
vainly1258503_vain_ly
wrathily1744773wrathily
wrinkly17295753wr_inkly
zanily18310183_za_nily

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621336.48622535.0
3Display Results1331330.0462891.3
 (SQL Overall)1786911336.93825755.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.