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

71 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
clabbering1710458(None) 
blabbering14104361blabbering
clambering1776161clambering
clobbering17103931clobbering
slabbering15104971slabbering
blubbering14103442blubbering
cambering16109872c_ambering
chambering20116042chambering
clattering13109232clattering
clavering1538372cla_vering
jabbering2134442_jabbering
slobbering15103882slobbering
slubbering15124922slubbering
yabbering1734022_yabbering
barbering14229683_barbering
blabbing12266723blabb__ing
blathering16107583blathering
blattering13108713blattering
cabbaging1744093c_abbaging
cabbing143613153c_abb__ing
calipering1545003calipering
cankering162110793c_ankering
cantering122417373c_antering
capering132414963c_a_pering
careering12311203c_areering
catering112019903c_a_tering
chaffering22104643chaffering
chamfering21125333chamfering
chaptering18107963chaptering
chartering16109253chartering
chattering16108643chattering
clabber134210113clabber___
clabbered16184763clabber_ed
clabbers14359903clabber__s
clamoring1477423cla_moring
clamouring15104773clamouring
clangoring1443913clangoring
clinkering1745233clinkering
clubbing15266513clubb__ing
clustering13116813clustering
cluttering13106833cluttering
crabbing15287933crabb__ing
cratering12312653cra_tering
cumbering16108203c_umbering
flambeing1743933flambe_ing
flattering1498743flattering
gibbering1534713_gibbering
laagering1136833_laagering
labeling11311643_la_beling
laboring112110143_la_boring
labouring1236213_labouring
lackering1639373_lackering
laddering1237593_laddering
lagering102212313_la_gering
lappering14258843_lappering
lathering13912253_lathering
laveering1336813_laveering
lawyering1655213_lawyering
layering122310353_la_yering
limbering1488793_limbering
lumbering14117933_lumbering
plastering1339243plastering
rabbeting1445183_rabbeting
rubbering1435703_rubbering
sabering112113743_sa_bering
slabbing13287783slabb__ing
slandering1237243slandering
slathering14108283slathering
slavering1338723sla_vering
slumbering15105323slumbering
tabering112211423_ta_bering

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 Filter1786911406030.406440125.6
2DLD Change Limit140603715.56325274.7
3Display Results71710.0302366.7
 (SQL Overall)178691715.99929786.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.