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

154 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
rubblier124491(None) 
bubblier1184471bubblier
nubblier1254411nubblier
bubbler103611782bubbl_er
bubblies1166772bubblies
burblier1255602burblier
crumblier1543872crumblier
grubbier13344752grubb_ier
nubbier11308132nubb_ier
pebblier1453262pebblier
rabbler113514092rabbl_er
ribbier1137592ribb_ier
rubber104715792rubb__er
rubberier1344392rubberier
rubbies114114112rubb_ies
rubble104315672rubbl_e_
rubbled124611622rubbl_ed
rubbles113715112rubbl_es
rubbliest1354692rubbliest
rubbling13238072rubbling
rubier84814742ru_b_ier
rufflier1434012rufflier
rulier65016352ru__lier
rumbler113514112rumbl_er
rumplier1235302rumplier
stubblier1343202stubblier
tubbier11237742tubb_ier
wabblier15375492wabblier
wobblier15325202wobblier
auntlier834903auntlier
babbler104012823babbl_er
belier84423563__belier
brabbler11397373brabbl_er
bramblier1543503bramblier
bubbies103913513bubb_ies
bubble94016593bubbl_e_
bubbled113612123bubbl_ed
bubblers11448943bubbl_ers
bubbles104315963bubbl_es
bubbliest1254423bubbliest
bubbling12248223bubbling
bullier94116433bu_llier
bumbler134013233bumbl_er
burbler114412423burbl_er
burlier93514413bu_rlier
chubbier1733893chubb_ier
clubbier1434833clubb_ier
cobbier133410163cobb_ier
cobbler133311823cobbl_er
crabbier14326803crabb_ier
crumbier1456363crumb_ier
crumplier1543783crumplier
cubbies133312883cubb_ies
cuddlier1234013cuddlier
curlier93314183cu_rlier
dabbler124012153dabbl_er
dibbler124510283dibbl_er
dribbler13316313dribbl_er
drubber12357863drubb__er
drumlier1134523dru_mlier
dubber113814553dubb__er
fribbler15265953fribbl_er
fubsier12367763fu_bsier
fumbler143610813fumbl_er
fusilier1135423fusilier
gabbier12379633gabb_ier
gabbler124013303gabbl_er
gobbler123310023gobbl_er
grabbier13316653grabb_ier
grabbler13377693grabbl_er
grubber12417913grubb__er
grumbler13866683grumbl_er
hobbler143710403hobbl_er
hubbies143211563hubb_ies
humbler143411943humbl_er
jumbler183910273jumbl_er
junglier1644303junglier
knobblier1741923knobblier
knubbier1642513knubb_ier
lubber104214623lubb__er
marblier1256343marblier
mumbler133510913mumbl_er
nibbler11379273nibbl_er
nobbier11309163nobb_ier
nobbler113211183nobbl_er
nubble103813713nubbl_e_
nubbles113412433nubbl_es
nubbliest1354363nubbliest
outlier72216143ou_tlier
puddlier1234213puddlier
quibbler2132843quibbl_er
rabbies113416053rabb_ies
rabbiter1234673rabbiter
rabble103818243rabbl_e_
rabbled123514423rabbl_ed
rabblers123810853rabbl_ers
rabbles113517973rabbl_es
rabbling13239333rabbling
rallier73816273r_allier
rambler113313263rambl_er
relier65826183r__elier
replier94214973r_eplier
ribber103515493ribb__er
ribier84414233r_ib_ier
ripplier1234463ripplier
robber103916533robb__er
roilier7311523r_oilier
rubbed114515083rubb__ed
rubbered1335383rubbered
rubbers113913193rubb__ers
rubbery14337593rubb__ery
rubbing123412273rubb_ing
rubbish1436303rubb_ish
rubbly133710613rubbl__y
rubied94312413ru_b_ied
rubies84420343ru_b_ies
ruble74521253ru_bl_e_
rubles83921703ru_bl_es
rubylike1753353rubylike
ruddier9338523ru_ddier
ruffler13369723ruffl_er
rugbies10339353rugb_ies
ruler54923343ru__l_er
rumble103718813rumbl_e_
rumbled124514593rumbl_ed
rumblers123610743rumbl_ers
rumbles114018393rumbl_es
rumbling131910103rumbling
rummier11309563ru_mmier
runnier74010113ru_nnier
runtier73512853ru_ntier
rushier103411973ru_shier
rustier74416363ru_stier
rustler73512343rustl_er
ruttier73412283ru_ttier
scrabblier1642773scrabblier
scrubbier1543333scrubb_ier
shrubbier1642193shrubb_ier
snubbier1244993snubb_ier
stubbier1235353stubb_ier
sublimer1237613su_blimer
subtiler10208573subtiler
subtler92910843subtl_er
supplier1246603supplier
surlier72915443su_rlier
tremblier1343283tremblier
tubber104313203tubb__er
tumbler113412823tumbl_er
uglier748953_u_glier
wabbler143511923wabbl_er
wamblier15275733wamblier
webbier1445423webb_ier
wobbler14329823wobbl_er
wobblies15297233wobblies

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.420425454.8
2DLD Change Limit1461621546.59622159.2
3Display Results1541540.0602566.7
 (SQL Overall)1786911547.07625253.1
 
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.