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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

87 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
brambles14308971brambl_es
bramblier1543501bramblier
brambliest1643771brambliest
brabbles11349752brabbl_es
bramble133710032brambl_e_
brambled15316732brambl_ed
brambling1635542brambling
bramblings1742612bramblings
brumbies1436532brumb_ies
rambles113118312_rambl_es
ramilies10311832_ramilies
ambles105121863__ambl_es
ambries111614553__ambries
arables91814973ara_bl_es
babbles104416323b_abbl_es
babies106123653b_a_b_ies
bailies94120203b_a_ilies
ballies93725743b_a_llies
barbies114519593b_arb_ies
barflies1338303b_arflies
baubles113611863b_aubl_es
bialies93618413bia__lies
brabble10349973brabbl_e_
brabbled12337633brabbl_ed
brabbler11397373brabbl_er
brabblers12335563brabblers
brabbling1334963brabbling
brailles1039493bra_illes
brambly16296253brambl__y
brandies11714563bra_ndies
brasilins1146243brasilins
brassies103613533bra_ssies
brattles10199333brattl_es
braveries1439103braveries
brawlie12198153bra_wlie_
brawlier13267043bra_wlier
brawliest14177193bra_wliest
braxies16711463bra__xies
brazilins2043963brazilins
brollies1039533br_ollies
bromelins1346463bromelins
bubblies1166773b_ubblies
bumbles134016843b_umbl_es
chimblies1845033chimblies
crambes1339963cramb__es
cramboes1436543cramb_oes
crumbles14329683crumbl_es
crumblier1543873crumblier
crumbliest1643903crumbliest
drabbles13308523drabbl_es
dramadies1344813dramadies
dramedies1345123dramedies
drumbles13277723drumbl_es
families1339443_families
framboise1642733framboise
framboises1742693framboises
gambles124016203_gambl_es
grabbles13339893grabbl_es
gramaries12128313gramaries
grumbles13288873grumbl_es
lambies113015113_lamb_ies
preambles1545333preambl_es
rabbies113416053_ra_bbies
rabbles113517973_rabbl_es
rabies85226023_ra_b_ies
rallies73823343_ra_llies
ramblas112710263_rambl_as
ramble104519973_rambl_e_
rambled123913523_rambl_ed
rambler113313263_rambl_er
ramblers124010373_ramblers
rambling131810773_rambling
ramies84630463_ram__ies
ramifies13310503_ramifies
ramilie9310283_ramilie_
ramillies1146133_ramillies
rumbles114018393_rumbl_es
scrambles15146383scrambl_es
shambles15159043shambl_es
tramlines1139843tram_lines
tramples122610203trampl_es
trembles1237353trembl_es
tremblier1343283tremblier
trembliest1443633trembliest
wambles143714023_wambl_es
wamblier15275733_wamblier
wambliest16255153_wambliest

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 Filter1786911486410.453394461.4
2DLD Change Limit148641877.14020818.1
3Display Results87870.0461891.3
 (SQL Overall)178691877.63923391.9
 
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.