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

86 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
marbling13179881marbling
garbling12249452garbling
marblier1256342marblier
marblings14225542marblings
marlin84220902mar_lin_
marline93320952mar_line
marling103322762mar_ling
marlins93420472mar_lins
warbling14198942warbling
ablins8316193_a_blins
aiblins9311473_aiblins
ambling121411793_ambling
argling92812733_argling
babbling12228693babbling
barbing123716993barb_ing
burbling13249423burbling
cabling124017553ca_bling
carbine112918643carb_ine
carlin84421823car_lin_
carline93923613car_line
carling103727063car_ling
carlins93921913car_lins
carlish12312763car_lish
caroling113317003caroling
dabbling14227973dabbling
darkling1437483darkling
darling93418363dar_ling
dartling1039563dartling
fabling133413623fa_bling
gabbling14238073gabbling
gabling113514543ga_bling
gambling14218963gambling
garbing113613273garb_ing
gargling11239203gargling
hardline12310273hardline
mackling172710063mackling
maculing13219583maculing
mailing102923343ma_iling
mainline1039863mainline
maline84529083ma__line
malling103623663ma_lling
mamboing1535973mamboing
mangling122312623mangling
mantling112012613mantling
marbelize2246113marbelize
marble104219103marbl__e
marbled123212113marbl_ed
marbleise1343483marbleise
marbleize2243073marbleize
marbler113511673marbl_er
marblers12319233marblers
marbles114516653marbl_es
marbliest1336763marbliest
marbly134111933marbl__y
marching164312193marching
margin94016843mar_gin_
margins103815193mar_gins
marina84623413mar__ina
marine84230403mar__ine
marish114319053mar__ish
marking144020133mar_king
marlier92614773mar_lier
marlines103818713mar_lines
marlings113713493mar_lings
marlite92917073mar_lite
marring103319553mar_ring
marrying14157223marrying
martin84122523mar_tin_
marting103325013mar_ting
martini93613873mar_tini
martins93322063mar_tins
marveling1537103marveling
maudlin1037163maudlin_
mauling103315683ma_uling
merlin83916683mer_lin_
merlins93015813mer_lins
mumbling15198533mumbling
parling103823763par_ling
paroling113316213paroling
purblind1345163purblind
rabbling13239333rabbling
rambling131810773rambling
tabling103216033ta_bling
wabbling16207743wabbling
wambling16198443wambling
warsling12198593warsling

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 Filter1786911461620.406440125.6
2DLD Change Limit146162866.48622535.0
3Display Results86860.0461869.6
 (SQL Overall)178691866.93825755.4
 
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.