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

129 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
jabbering213444(None) 
yabbering1734021yabbering
barbering14229692barbering
blabbering14104362blabbering
cambering16109872cambering
clabbering17104582clabbering
gibbering1534712gibbering
jabbing19319412jabb__ing
rabbeting1445182rabbeting
rubbering1435702rubbering
sabering112113742sa_bering
slabbering15104972slabbering
tabering112211422ta_bering
abjuring1834883_abjuring
adhering1338883_adhering
altering91917123_altering
amberina1247403_amberina
angering102113803_angering
babbling12228693babb_ling
badgering1436973badgering
bannering12208813bannering
bantering122414243bantering
bartering122313653bartering
battering122715153battering
blubbering14103443blubbering
cabbaging1744093cabbaging
cabbing143613153cabb__ing
cankering162110793cankering
cantering122417383cantering
capering132414973ca_pering
careering12311203careering
catering112019923ca_tering
chambering20116043chambering
clambering1776163clambering
clobbering17103933clobbering
cumbering16108203cumbering
dabbing133511233dabb__ing
dabbling14227973dabb_ling
dackering1737393dackering
daggering13246113daggering
daikering1536103daikering
dandering122511063dandering
dangering12239303dangering
faltering132211123faltering
fathering161010093fathering
gabbing133512033gabb__ing
gabbling14238073gabb_ling
gandering122111293gandering
garnering11298093garnering
gartering112111593gartering
gathering1499463gathering
gibbeting1542903gibbeting
haltering132212013haltering
hammering1737633hammering
hampering1738863hampering
hankering17239383hankering
harboring1538263harboring
havering152211053ha_vering
jabber173713643jabber___
jabbered2034433jabber_ed
jabberer1944023jabber_er
jabberers2043553jabberers
jabbers183610583jabber__s
jacketing2345643jacketing
jambing19328533jamb__ing
jarring153613193ja__rring
jawboning22133413jawboning
jeering153513043j__eering
jibbing19338063jibb__ing
jiggering1934303jiggering
jittering17218423jittering
jobberies20115423jobberies
jobbing19279013jobb__ing
juddering1933763juddering
kashering1736253kashering
laagering1136833laagering
labeling11311653la_beling
laboring112110143la_boring
labouring1236213labouring
lackering1639383lackering
laddering1237593laddering
lagering102212313la_gering
lappering14258843lappering
lathering13912253lathering
laveering1336813laveering
lawyering1655213lawyering
layering122310353la_yering
limbering1488793limbering
lumbering14117933lumbering
mammering1337333mammering
mastering122315313mastering
mattering122314063mattering
nabbing12299963nabb__ing
nattering102212223nattering
numbering14107003numbering
paltering122612903paltering
pampering1638383pampering
pandering133211963pandering
papering132213313pa_pering
pattering122314433pattering
paupering1437273paupering
rabbiting1445033rabbiting
rabbling13239333rabb_ling
sabbing123314743sabb__ing
sabeing102611863sa_be_ing
sabring102614843sa_b_ring
saggering12197793saggering
slobbering15103883slobbering
slubbering15124923slubbering
sobering111912793_sobering
tabbing123611913tabb__ing
tabbying1633973tabb_ying
tableting1236353tableting
taboring113010193ta_boring
tabouring1245723tabouring
tampering1438453tampering
tapering112112503ta_pering
tattering102212333tattering
timbering14117723timbering
umbering1399433_umbering
wabbling16207743wabb_ling
wafering15208893wa_fering
wagering13219523wa_gering
waitering13310723waitering
wandering143310983wandering
watering122316323wa_tering
wavering152410543wa_vering
yammering1735193yammering
yattering132410453yattering

Search took 9 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 Filter1786911486410.420425454.8
2DLD Change Limit1486411298.33017844.1
3Display Results1291290.0632047.6
 (SQL Overall)1786911298.81320275.8
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.