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 “brandlings” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

82 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
brandlings144399(None) 
brandings13277481brand_ings
brandling1348251brandling_
bantlings12216602b_antlings
braidings13285902braid_ings
bramblings1742612bramblings
branding122513682brand_ing_
brandying1654882brandying_
bundlings13235562b_undlings
handlings14237342_handlings
sandlings11238092_sandlings
anglings10228273__anglings
babblings13194373b_abblings
banding114921413b_and_ing_
bandying15218073b_andying_
bankings15489403b_an_kings
bantling112612003b_antling_
beadings123711783bea_d_ings
bindings123810473b_ind_ings
bladings12337753bla_d_ings
boardings13296063board_ings
bondings12369413b_ond_ings
brabbling1334963brabbling_
bracings13369293bra__cings
bradding13268933bra_dding_
braiding123112703braid_ing_
brailing113514793bra_iling_
brailling1247773brailling_
brambling1635543brambling_
branching17289263branching_
branchlines1843613branchlines
brandies11714563brand_i_es
brandless1236123brandl_ess
branning112911093bran_ning_
brasilins1146243brasilin_s
brattling1236003brattling_
brawling143210043bra_wling_
brazilins2043963brazilin_s
breadlines1345733breadlines
breedings13375763breed_ings
bridgings14254293br_idgings
bridling122610583br_idling_
brislings12236363br_islings
bronzings2143643bron_zings
bundling12219703b_undling_
bunglings13235213b_unglings
candling122313873_candling_
cracklings19143523cracklings
cradling122411453cra_dling_
crankling16147293crankling_
dandling112511733_dandling_
eanlings9128473_ean_lings
fondlings14224893_fondlings
foundlings1542913foundlings
franklins1694763franklin_s
grapplings1642323grapplings
graylings1433883gra_ylings
groundlings1442073groundlings
handling132312713_handling_
kindlings15195273_kindlings
landings103110073_land_ings
landlines1039763_landlines
mantlings12207233_mantlings
paddlings14224363_paddlings
panelings12107453_panelings
raddling11229773_raddling_
railings93412153_ra_ilings
rankings13389173_ran_kings
rankling132610113_rankling_
rattlings10235513_rattlings
ravelings13377383_ravelings
reedlings11236343_reedlings
sandling102214413_sandling_
scantlings1393313scantlings
standings11257153stand_ings
strandlines1244963strandlines
trindling1137133trindling_
trundling1135003trundling_
weanlings1394413wean_lings
windlings14236723_windlings
wrangling1456223wrangling_
yeanlings1393693yean_lings

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 Filter1786911406030.423422437.4
2DLD Change Limit140603826.67021079.9
3Display Results82820.0501640.0
 (SQL Overall)178691827.14325016.2
 
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.