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

52 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
barrelling134545(None) 
barreling1238041barre_ling
ferrelling1445062ferrelling
laurelling1144462laurelling
marcelling1545592marcelling
marvelling1645362marvelling
parcelling1546172parcelling
quarrelling2143402quarrelling
arresting1038633_arresting
aureoling1045873_aureoling
balling104424763ba___lling
bankrolling1852303bankrolling
barbecuing1752323barbecuing
barbequing2462033barbequing
barbering14229683barbe_ring
barracking1944713barracking
barraging1337383barr_aging
barrelled1245263barrell_ed
barring104021593barr___ing
bartending1444913bartending
bartering122313643barte_ring
belling103825073b___elling
bevelling15227453b_evelling
bowelling1566493b_owelling
brailling1247773b_railling
bushelling1644063bushelling
cancelling1547213cancelling
carolling1259413ca_rolling
corbelling1546713corbelling
cordelling1446383cordelling
corralling1345433corralling
farewelling1842623farewelling
ferreling13136273ferre_ling
gavelling14286873ga_velling
gravelling1565213gravelling
gruelling1155603_gruelling
hanselling1445623hanselling
hirselling1444833hirselling
kernelling1584143kernelling
labelling1238083la_belling
laureling1035643laure_ling
marveling1537103marve_ling
morselling1346323morselling
panelling1239073pa_nelling
parceling1438443parce_ling
patrolling1345693patrolling
quarreling2043663quarre_ling
rappelling1544363rappelling
ravelling13269243ra_velling
tasselling1145233tasselling
tramelling1346373tramelling
travelling1456533travelling

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 Filter1786911406030.406440125.6
2DLD Change Limit140603525.51625490.0
3Display Results52520.0163250.0
 (SQL Overall)178691525.93830092.8
 
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.