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

131 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
nubblier125441(None) 
bubblier1184471bubblier
nubbier11308131nubb_ier
rubblier1244911rubblier
bubbler103611782bubbl_er
bubblies1166772bubblies
burblier1255602burblier
knobblier1741922knobblier
knubbier1642512knubb_ier
nibbler11379272nibbl_er
nobbier11309162nobb_ier
nobbler113211182nobbl_er
nubble103813712nubbl_e_
nubbles113412432nubbl_es
nubbliest1354362nubbliest
pebblier1453262pebblier
snubbier1244992snubb_ier
stubblier1343202stubblier
tubbier11237742tubb_ier
wabblier15375492wabblier
wobblier15325202wobblier
auntlier834903auntlier
babbler104012823babbl_er
belier84423563__belier
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
crumblier1543873crumblier
cubbies133312883cubb_ies
cuddlier1234013cuddlier
curlier93314183cu_rlier
dabbler124012153dabbl_er
dibbler124510283dibbl_er
dubber113814553dubb__er
fubsier12367763fu_bsier
fumbler143610813fumbl_er
fusilier1135423fusilier
gabbier12379633gabb_ier
gabbler124013303gabbl_er
gobbler123310023gobbl_er
grubbier13344753grubb_ier
hobbler143710403hobbl_er
hubbies143211563hubb_ies
humbler143411943humbl_er
jumbler183910273jumbl_er
junglier1644303junglier
knobbier1652703knobb_ier
knucklier1442303knucklier
knurlier1242883knu_rlier
lubber104214623lubb__er
marblier1256343marblier
mumbler133510913mumbl_er
nabber104913543nabb__er
nearlier836793nearlier
nebulizer2043263nebulizer
nettlier864813nettlier
nibble103713283nibbl_e_
nibbled12389073nibbl_ed
nibblers12306543nibbl_ers
nibbles114011693nibbl_es
nibbling13256503nibbling
nigglier1044843nigglier
nimbler11358063nimbl_er
nobble103814313nobbl_e_
nobbled123511283nobbl_ed
nobblers12318563nobbl_ers
nobbles114014523nobbl_es
nobbling13228273nobbling
nobler83713453n_obl_er
nubbiest12117313nubb_iest
nubbin10308293nubb_i_n
nubbins11268023nubb_ins
nubbly13369673nubbl__y
nubile83212713nubil_e_
nubility1347783nubility
number103913223numb__er
numberer12186313numberer
numbles113814273numbl_es
nutsier7329253nu_tsier
nuttier73112023nu_ttier
nuzzler15296493nuzzl_er
outlier72216143ou_tlier
puddlier1234213puddlier
quibbler2132843quibbl_er
rabbler113514093rabbl_er
ribbier1137593ribb_ier
rubber104715793rubb__er
rubberier1344393rubberier
rubbies114114113rubb_ies
rubble104315673rubbl_e_
rubbled124611623rubbl_ed
rubbles113715113rubbl_es
rubbliest1354693rubbliest
rubbling13238073rubbling
rubier84814743ru_b_ier
rufflier1434013rufflier
rulier65016353ru__lier
rumbler113514113rumbl_er
rumplier1235303rumplier
snobbier1234633snobb_ier
snubber11277733snubb__er
snufflier1543303snufflier
stubbier1235353stubb_ier
sublimer1237613su_blimer
subtiler10208573subtiler
subtler92910843subtl_er
supplier1246603supplier
surlier72915443su_rlier
tubber104313203tubb__er
tumbler113412823tumbl_er
uglier748953_u_glier
unbelief1346773unbelief
unholier1137283unholier
unrulier845333unrulier
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.1561145455.1
2DLD Change Limit1461621317.40619735.6
3Display Results1311310.0462847.8
 (SQL Overall)1786911317.60823487.3
 
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.