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 “rabbles” with Change Limit: [1] [2]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

105 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
rabbles11351797(None) 
babbles104416321babbles
brabbles11349751brabbles
dabbles124514771dabbles
drabbles13308521drabbles
gabbles124415411gabbles
grabbles13339891grabbles
rabbies113416051rabbies
rabble103818241rabble_
rabbled123514421rabbled
rabbler113514091rabbler
rabblers123810851rabblers
rambles113118311rambles
rubbles113715111rubbles
wabbles144013991wabbles
abbes96723522_abb_es
abeles84719392_abeles
ables75935542_a_bles
ambles105121862_ambles
arables91814972arables
babble94017112babble_
babbled113612862babbled
babbler104012822babbler
babblers113510352babblers
baubles113611862baubles
bobbles104514912bobbles
brabble10349972brabble_
brabbled12337632brabbled
brabbler11397372brabbler
brabblers12335562brabblers
brambles14308972brambles
bubbles104315962bubbles
cabbies133115162cabbies
cables104527552ca_bles
cobbles133814822cobbles
dabble114515192dabble_
dabbled133712072dabbled
dabbler124012152dabbler
dabblers13379362dabblers
dibbles124013332dibbles
drabble12238882drabble_
drabbled14367052drabbled
dribbles13348392dribbles
fables114921672fa_bles
fribbles15287712fribbles
gabble113815722gabble_
gabbled134112452gabbled
gabbler124013302gabbler
gabblers134110082gabblers
gables94222332ga_bles
gambles124016202gambles
garbles104016922garbles
gobbles123512582gobbles
grabble12339642grabble_
grabbled14327372grabbled
grabbler13377692grabbler
grabblers14345512grabblers
gribbles13307362gribbles
hobbles143313782hobbles
kibbles153510252kibbles
marbles114516652marbles
nibbles114011692nibbles
nobbles114014522nobbles
nubbles113412432nubbles
pebbles1337572pebbles
rabbet103818652rabb_et
rabbets11279422rabbets
rabbins112811342rabbins
rabbis102613162rabb_is
rabbits11299862rabbits
rabies85226022ra_bies
raddles93615702raddles
raffles133611842raffles
raggles93813282raggles
rales54947492ra__les
ramblas112710262ramblas
ramble104519972ramble_
rambled123913522rambled
rambler113313262rambler
ramblers124010372ramblers
rankles113114542rankles
rassles73513922rassles
ratables10159722ratables
rattles73217302rattles
rebbes10313532rebb_es
robles85321692r_obles
roubles93413512roubles
rubbies114114112rubbies
rubble104315672rubble_
rubbled124611622rubbled
rubles83921702r_ubles
rumbles114018392rumbles
sables85026692sa_bles
scabbles14167982scabbles
scrabbles15206282scrabbles
tabbies112913502tabbies
tables84524892ta_bles
wabble133714842wabble_
wabbled153311442wabbled
wabbler143511922wabbler
wabblers15398992wabblers
wambles143714022wambles
warbles123215562warbles
wobbles143412432wobbles
yabbies14279642yabbies

Search took 4 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 Filter1786911076710.376475242.0
2DLD Change Limit1076711053.06335152.1
3Display Results1051050.0303500.0
 (SQL Overall)1786911053.46951510.8
 
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.