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

153 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
jabbered203443(None) 
jabberer1944021jabberer
yabbered1633961yabbered
barbered13259542barbered
blabbered13184592blabbered
cambered15129002cambered
clabbered16184762clabbered
gibbered1444302gibbered
jabbed184213482jabb__ed
jabber173713642jabber__
jabberers2043552jabberers
jabbers183610582jabber_s
rabbeted1334442rabbeted
rubbered1335382rubbered
sabered103213022sa_bered
slabbered14165082slabbered
tabered103311592ta_bered
abjured1735083_abjured
adhered1239233_adhered
altered83215743_altered
angered93013473_angered
arbored103811603_arbored
babbled113612863babb_led
badgered1336213badgered
bannered11299323bannered
bantered113313633bantered
bartered113113013bartered
battered113315053battered
blubbered13164113blubbered
cabbaged1644383cabbaged
cabbed135416263cabb__ed
cancered132411553cancered
cankered153010223cankered
cantered113415983cantered
capered123014043ca_pered
careered1139493careered
catered103117773ca_tered
chambered19145993chambered
clambered16146133clambered
clobbered16164103clobbered
cumbered15157963cumbered
dabbed124416143dabb__ed
dabber114816963dabber__
dabbers123813213dabber_s
dabbled133712073dabb_led
dackered16116893dackered
daggered12246403daggered
daikered1495223daikered
dandered112110963dandered
dangered11248513dangered
fabber134814113fabber__
faltered122810993faltered
fathered151510433fathered
fibered1337643_fibered
gabbard1336553gabbar_d
gabbed125216893gabb__ed
gabber114916603gabber__
gabbers124612833gabber_s
gabbled134112453gabb_led
gandered112211173gandered
garnered10247113garnered
gartered10319593gartered
gathered13149383gathered
gibbeted1492783gibbeted
halberd1336053halber_d
haltered123112563haltered
hammered16218853hammered
hampered16239933hampered
hankered16289443hankered
harbored1438633harbored
havered144011453ha_vered
jabbering2134443jabbering
jacketed22146533jacketed
jambed184811403jamb__ed
jamboree1944863jamboree
jarred144613253ja__rred
jawboned21133553jawboned
jaybird2043123jaybir_d
jeered143912793j__eered
jibbed184810563jibb__ed
jibber174111243jibber__
jibbers18449703jibber_s
jiggered1834203jiggered
jittered16267223jittered
jobbed184212133jobb__ed
jobber173813353jobber__
jobberies20115423jobberies
jobbers182911133jobber_s
jobbery21366013jobber_y
juddered1833583juddered
kashered1636403kashered
laagered1055853laagered
labeled102510563la_beled
labored102810253la_bored
laboured1156333laboured
lackered15108683lackered
laddered1136743laddered
lagered92311153la_gered
lappered13288213lappered
lathered121512333lathered
laveered1235253laveered
lawyered1534033lawyered
layered11259413la_yered
limbered13158123limbered
lumbered13188233lumbered
mammered12237653mammered
mannered11249653mannered
mastered112614003mastered
mattered112412903mattered
membered1535903membered
nabbed115113613nabb__ed
nabber104913543nabber__
nabbers113710463nabber_s
nattered92011623nattered
numbered13147143numbered
paltered113012493paltered
pampered15229233pampered
pandered121812573pandered
papered122513173pa_pered
pattered112714203pattered
paupered13216943paupered
rabbited1334763rabbited
rabbled123514423rabb_led
raftered1237663raftered
rapiered1136053rapiered
sabbed114518083sabb__ed
sabred95916533sa_b_red
saggered11237553saggered
slobbered14144223slobbered
slubbered14175253slubbered
sobered102912433_sobered
subbreed1345873subbreed
tabbed114215363tabb__ed
tabbied12297793tabb_ied
tableted1137533tableted
tabored102810563ta_bored
taboured1156273taboured
tampered13279463tampered
tapered102612933ta_pered
tattered92011443tattered
timbered13137383timbered
umbered121510113_umbered
wabbled153311443wabb_led
wafered14288433wa_fered
wagered12299333wa_gered
waitered1238753waitered
wandered132110793wandered
watered113014953wa_tered
wavered142910433wa_vered
yabber136111833yabber__
yabbers14389353yabber_s
yammered16225763yammered
yattered12239533yattered

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 Filter1786911461620.406440125.6
2DLD Change Limit1461621536.76621602.4
3Display Results1531530.0602550.0
 (SQL Overall)1786911537.23224708.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.