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

129 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
abubble104452(None) 
bubble94016591_bubble
abusable1236372abusable
babble94017112_babble
bauble103813212bau_ble
bobble94115142_bobble
bubale104014622_bubale
bubbled113612122_bubbled
bubbler103611782_bubbler
bubbles104315962_bubbles
bubbly124110352_bubbly
bumble124216892_bumble
burble104617702_burble
nubble103813712_nubble
rubble104315672_rubble
stubble1136842stubble
abatable1238023abatable
abaxile1644083abaxile
abbe87627193a__bb_e
abele76323253a__bele
able66340533a___ble
abuse77119563abu__se
abusive1245283abusive
actable11313473actable
addable11218843addable
addible11236063addible
affable15117403affable
alible8311973a_lible
amble95924643a__mble
amiable11312033amiable
amusable1237143amusable
arable81821003a_rable
arbuscle1242883arbuscle
arguable1135903arguable
aubade939223a_ubade
audible10228243audible
audile73315303a_udile
babbled113612863_babbled
babbler104012823_babbler
babbles104416323_babbles
barbule1137943barbule
baubee103215993bau_bee
baubles113611863bau_bles
bible95119423_b_ible
bobbled113811833_bobbled
bobbles104514913_bobbles
brabble10349973brabble
bubal94218213_bubal_
bubales113513343_bubales
bubals103513843_bubals
bubba84311803_bubb_a
bubbas94110703_bubbas
bubbies103913513_bubbies
bubblers11448943_bubblers
bubblier1184473_bubblier
bubblies1166773_bubblies
bubby115013933_bubb_y
buckle144815193_buckle
buddle104313083_buddle
bugle84721943_bu_gle
bulbel104510683_bulbel
bulblet11311213_bulblet
bumbled144113043_bumbled
bumbler134013233_bumbler
bumbles134016843_bumbles
bundle94315573_bundle
bungle97116113_bungle
burbled124312673_burbled
burbler114412423_burbler
burbles114916803_burbles
burbly134311153_burbly
burgle94815863_burgle
bustle84015483_bustle
butle75023103_bu_tle
buyable1437493_buyable
clubable1436093clubable
cobble123615263_cobble
crumble133410403crumble
dabble114515193_dabble
dibble114013843_dibble
double94013993dou_ble
drabble12238883drabble
dribble12368603dribble
drumble12337893drumble
equable1849253equable
fribble14287783fribble
fumble133214263_fumble
gabble113815723_gabble
gobble113512983_gobble
grabble12339643grabble
gribble12297273gribble
grumble12349233grumble
hobble133913433_hobble
hubbly16478413_hubbly
humble133615053_humble
jubile152910263_jubile
jumble174012653_jumble
kibble143910953_kibble
mumble123614343_mumble
nibble103713283_nibble
nobble103814313_nobble
nubbles113412433_nubbles
nubbly13369673_nubbly
nubile83212713_nubile
pebble1238003_pebble
quibble2034713quibble
rabble103818243_rabble
rouble83913313rou_ble
rubbled124611623_rubbled
rubbles113715113_rubbles
rubbly133710613_rubbly
ruble74521253_ru_ble
rumble103718813_rumble
scabble13168653scabble
scumble1337013scumble
squabble2143883squabble
stubbled1385073stubbled
stubbles1236843stubbles
stubbly1444473stubbly
stumble1147553stumble
suable83920553_suable
subtle82113433_subtle
tabulable1344043tabulable
tubbable1134683tubbable
tubule839853_tubule
tumble103215643_tumble
valuable1336863valuable
wabble133714843_wabble
wobble133212313_wobble

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.500357382.0
2DLD Change Limit1340271295.92322628.2
3Display Results1291290.0462804.3
 (SQL Overall)1786911296.46927622.7
 
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.