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

140 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
rubbered133538(None) 
blubbered13164112blubbered
cumbered15157952cumbered
gibbered1444302gibbered
jabbered2034432jabbered
lumbered13188232lumbered
numbered13147142numbered
rabbeted1334442rabbeted
rubbed114515082rubb__ed
rubber104715792rubber__
rubberier1344392rubberier
rubberized24143002rubberized
rubbers113913182rubber_s
rubbery14337592rubber_y
rubbled124611622rubb_led
slubbered14175252slubbered
subbreed1345872subbreed
umbered121510112_umbered
yabbered1633962yabbered
barbered13259543barbered
blabbered13184593blabbered
blubberer12173453blubberer
bubbled113612123bubb_led
buffered1764993buffered
buggered1335623buggered
bumpered1536003bumpered
bunkered15177183bunkered
buttered112712623buttered
cambered15128993cambered
clabbered16184753clabbered
clobbered16164103clobbered
cumberer14266993cumberer
drubbed13406983drubb__ed
drubber12357863drubber__
drubbers13386023drubber_s
dubbed124113213dubb__ed
dubber113814553dubber__
dubbers124011823dubber_s
fibered1337643_fibered
fubbed144711243fubb__ed
fullered1236383fullered
gibbeted1492783gibbeted
grubbed13406433grubb__ed
grubber12417913grubber__
grubbers13316193grubber_s
guttered10259153guttered
hungered13217053hungered
hunkered16186923hunkered
jabberer1944023jabberer
juddered1833583juddered
limbered13158123limbered
lubber104214623lubber__
lubberly1543663lubberly
lubbers113913723lubber_s
lumberer12177583lumberer
lustered92510603lustered
membered1535903membered
murdered1236023murdered
mustered112511503mustered
muttered112610793muttered
numberer12186313numberer
outbred10311263outb_red
outbreed1138503outbreed
puckered1736103puckered
purebred1344253purebred
puttered112611143puttered
quavered2144813quavered
queered17117213qu_eered
quivered2144823quivered
rabbited1334763rabbited
rabbled123514423rabb_led
raftered1237663raftered
rapiered1136053rapiered
rebored105015883r_ebored
rebred95816353r_eb_red
rebreed104611073rebre_ed
rendered102512263rendered
renumbered15102863renumbered
reuttered1036073reuttered
revered112819333r_evered
ribbed114014373ribb__ed
ribber103515493ribber__
ribbers113913183ribber_s
ribboned1343973ribboned
robbed113415193robb__ed
robber103916533robber__
robberies13107393robberies
robbers112814153robber_s
robbery14348283robber_y
rogered939553r_ogered
rubberiest1444393rubberiest
rubbering1435703rubbering
rubberize22133693rubberize
rubberizes23133823rubberizes
rubberneck2051393rubberneck
rubbies114114113rubb_ies
rubble104315673rubb_le_
rubbles113715113rubb_les
rubblier1244913rubblier
rubboard1343973rubboard
rubied94312413ru_b_ied
rubier84814743rubier__
rumbaed12287493rumb_aed
rumbled124514593rumb_led
rumored1046643ru_mored
rumoured1143783rumoured
ruptured1144683ruptured
sabered103213023_sabered
slabbered14165083slabbered
slobbered14144223slobbered
slumbered14215593slumbered
sobered102912433_sobered
subbed114116673subb__ed
subbreeds1443573subbreeds
submerged1544603submerged
submersed1445863submersed
subsere9311443subsere_
subseres10312423subseres
subserved1545143subserved
subvened1436423subvened
subverted1545443subverted
suckered1537833suckered
suffered1536733suffered
summered1338143summered
sundered10312153sundered
supered10316123su_pered
tabered103311593_tabered
timbered13137383timbered
truebred1142753trueb_red
tubbed114712223tubb__ed
tubber104313203tubber__
tubbers113411243tubber_s
tuckered1535963tuckered
ulcered1037973_ulcered
umbeled12208193_umbeled
unbeared111611653_unbeared
unbred92613303_unb_red
ushered1139153_ushered
uttered82712433_uttered
wuthered15157433wuthered

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461621407.90618487.5
3Display Results1401400.0632222.2
 (SQL Overall)1786911408.12521992.7
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.