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

138 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
yabbered163396(None) 
jabbered2034431jabbered
barbered13259552barbered
blabbered13184592blabbered
cambered15129002cambered
clabbered16184762clabbered
gibbered1444302gibbered
jabberer1944022jabberer
rabbeted1334442rabbeted
rubbered1335382rubbered
sabered103213022sa_bered
slabbered14165082slabbered
tabered103311592ta_bered
yabber136111832yabber__
yabbers14389352yabber_s
yammered16225762yammered
yattered12239542yattered
abjured1735083_abjured
adhered1239233_adhered
altered83215753_altered
angered93013473_angered
arbored103811603_arbored
babbled113612863babb_led
badgered1336213badgered
bannered11299323bannered
bantered113313653bantered
bartered113113033bartered
battered113315073battered
blubbered13164113blubbered
cabbaged1644383cabbaged
cabbed135416263cabb__ed
cancered132411553cancered
cankered153010223cankered
cantered113415993cantered
capered123014043ca_pered
careered1139503careered
catered103117783ca_tered
chambered19145993chambered
clambered16146133clambered
clobbered16164103clobbered
cumbered15157963cumbered
dabbed124416143dabb__ed
dabber114816963dabber__
dabbers123813213dabber_s
dabbled133712073dabb_led
dackered16116893dackered
daggered12246403daggered
daikered1495223daikered
dandered112110963dandered
dangered11248513dangered
fabber134814113fabber__
faltered122811003faltered
fathered151510433fathered
fibered1337643_fibered
gabbard1336553gabbar_d
gabbed125216893gabb__ed
gabber114916603gabber__
gabbers124612833gabber_s
gabbled134112453gabb_led
gandered112211173gandered
garnered10247123garnered
gartered10319603gartered
gathered13149383gathered
gibbeted1492783gibbeted
halberd1336053halber_d
haltered123112573haltered
hammered16218853hammered
hampered16239933hampered
hankered16289443hankered
harbored1438643harbored
havered144011453ha_vered
jabbed184213483jabb__ed
jabber173713643jabber__
jabberers2043553jabberers
jabbers183610583jabber_s
kashered1636403kashered
laagered1055853laagered
labeled102510563la_beled
labored102810253la_bored
laboured1156333laboured
lackered15108683lackered
laddered1136743laddered
lagered92311153la_gered
lappered13288213lappered
lathered121512333lathered
laveered1235253laveered
lawyered1534033lawyered
layered11259413la_yered
limbered13158123limbered
lumbered13188233lumbered
mammered12237653mammered
mannered11249653mannered
mastered112614013mastered
mattered112412913mattered
membered1535903membered
nabbed115113613nabb__ed
nabber104913543nabber__
nabbers113710463nabber_s
nattered92011633nattered
numbered13147143numbered
paltered113012503paltered
pampered15229233pampered
pandered121812573pandered
papered122513173pa_pered
pattered112714213pattered
paupered13216943paupered
rabbited1334763rabbited
rabbled123514423rabb_led
raftered1237673raftered
rapiered1136053rapiered
sabbed114518083sabb__ed
sabred95916533sa_b_red
saggered11237553saggered
slobbered14144223slobbered
slubbered14175253slubbered
sobered102912433_sobered
subbreed1345873subbreed
tabbed114215363tabb__ed
tabbied12297793tabb_ied
tableted1137533tableted
tabored102810563ta_bored
taboured1156273taboured
tampered13279463tampered
tapered102612933ta_pered
tattered92011453tattered
timbered13137383timbered
umbered121510113_umbered
wabbled153311443wabb_led
wafered14288433wa_fered
wagered12299333wa_gered
waitered1238763waitered
wandered132110793wandered
watered113014963wa_tered
wavered142910433wa_vered
yabbering1734023yabbering
yabbie13308663yabb_ie_
yabbies14279643yabb_ies
yammerer15225483yammerer

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 Filter1786911461620.410435831.7
2DLD Change Limit1461621386.23323449.7
3Display Results1381380.0463000.0
 (SQL Overall)1786911386.68926714.2
 
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.