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

159 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
rubbish143630(None) 
cubbish1635801cubbish
rubbishy1842151rubbishy
clubbish1743812clubbish
furbish1536442furbish
mobbish1635922mobbish
nebbish1444252nebbish
publish1447912publish
rabbis102613162rabbis_
rubbies114114112rubbies
rubbing123412272rubbing
rubbishes1644302rubbishes
runtish1048692runtish
ruttish1048302ruttish
babyish1736513babyish
boobish14338943boobish
brutish1237703bru_tish
bubbas94110703bubbas_
bubbies103913513bubbies
buckish18237883buckish
bullish12511193bullish
burnish1238623burnish
cubbies133312883cubbies
cubism12348703cu_bism
cubist104214443cu_bist
cuish10313173cu__ish
cultish12139113cultish
currish1238353currish
drubbing14286053drubbing
drumfish1743503drumfish
dubbin11329263dubbi_n
dubbing133311213dubbing
dubbins12358803dubbins
dudish1148313du_dish
dullish1148743dullish
dumpish15116113dumpish
duncish1335793duncish
duskish1535183duskish
frumpish1843503frumpish
fubbing15409573fubbing
furnish1337383furnish
grubbier13344753grubbier
grubbiest1434253grubbiest
grubbily1642973grubbily
grubbing14295403grubbing
gruffish1843943gruffish
grumpish1643763grumpish
hubbies143211563hubbies
hubris11218973hubris_
huffish1935713huffish
hunnish1336163hunnish
jubbah2034353jubb_ah
jubbahs2143623jubbahs
kibbis14398473kibbis_
krubis1235003kru_bis_
kurbash1643803kurbash
lumpish14127383lumpish
mobbism1535053mobbism
mudfish1646263mudfish
mulish11311903mu_lish
nabobish1544103nabobish
nebbishy1841303nebbishy
nubbier11308133nubbier
nubbiest12117313nubbiest
nubbin10308293nubbi_n
nubbins11268023nubbins
numbfish1842603numbfish
nunnish1035933nunnish
outfish132210573outfish
outwish13289853outwish
prudish1376563pru_dish
pubis94616473pu_bis_
puckish18237213puckish
puggish14265993puggish
punish111411503pu_nish
punkish16257693punkish
pupfish1735533pupfish
rabbi93113183rabbi__
rabbies113416053rabbies
rabbin103112303rabbi_n
rabbins112811343rabbins
rabbit102914563rabbi_t
rabbits11299863rabbits
rabbity14266303rabbity
radish103516913r_adish
raffish1658843raffish
rakish134313963r_akish
rammish1437563rammish
rankish14510383rankish
raspish1298103raspish
ratfish1338773ratfish
rattish10510823rattish
ravish123414033r_avish
rawish123012913r_awish
rebbes10313533rebbes_
reddish1238033reddish
redfish1437793redfish
refurbish1743213refurbish
relish93916953r_elish
republish1643823republish
ribbier1137593ribbier
ribbiest1237583ribbiest
ribbing123111953ribbing
robbin103611183robbi_n
robbing123313213robbing
robbins112811063robbins
roguish1156833roguish
rompish1436693rompish
roughish1545213roughish
roundish1246253roundish
rubasse934903rubasse
rubbed114515083rubb_ed
rubber104715793rubb_er
rubbers113913193rubbers
rubbery14337593rubbery
rubbings13306333rubbings
rubble104315673rubb_le
rubbled124611623rubbled
rubbles113715113rubbles
rubblier1244913rubblier
rubbliest1354693rubbliest
rubbling13238073rubbling
rubbly133710613rubb_ly
rubby124413863rubb__y
rubels84112993rubels_
rubes74928413ru_bes_
rubied94312413ru_bied
rubier84814743ru_bier
rubies84420343ru_bies
rubiest92914423rubiest
rubigo935053ru_bigo
rubles83921703rubles_
rubric1097823rubri_c
rubrics1177093rubrics
rubs66133493ru_b_s_
rubus76415063ru_bus_
rubying13297933rubying
rugbies10339353rugbies
rumbas102512013rumbas_
rupiah1146213ru_piah
rush76628183ru___sh
slobbish1544263slobbish
snobbish1544213snobbish
subbase1139323subbase
subbass1138033subbass
subbing123915583subbing
submiss1138083submiss
subsist9311573subsist
sunfish1338883sunfish
tabbis102910863tabbis_
tubaist938703tubaist
tubbier11237743tubbier
tubbiest12117293tubbiest
tubbing123510093tubbing
tubist83013163tu_bist
tundish1137283tundish
turbith1267113turbith
unwish1239093_unwish
uppish1336633_uppish

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271596.06322105.7
3Display Results1591590.0463456.5
 (SQL Overall)1786911596.51527427.6
 
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.