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

161 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
marblings1422554(None) 
marbling13179881marbling_
marlings113713491mar_lings
ablings1038742_a_blings
babblings13194372babblings
carlings114015862car_lings
dabblings15193882dabblings
darklings1533982darklings
darlings103710382dar_lings
garbling12249452garbling_
mailings113011922ma_ilings
mallings113413092ma_llings
mantlings12207232mantlings
markings153410242mar_kings
marlines103818712mar_lines
marling103322762mar_ling_
marlins93420472mar_lin_s
warbling14198942warbling_
ablins8316193_a_blin_s
aiblins9311473_aiblin_s
ambling121411793_ambling_
anglings10228273_anglings
archings14499863_archings
argling92812733_argling_
armings103811503_ar_mings
babbling12228693babbling_
bantlings12216603bantlings
barbing123716993barb_ing_
birlings11359613bir_lings
bramblings1742613bramblings
bumblings16194753bumblings
burbling13249423burbling_
cabling124017553ca_bling_
cagelings1335413cagelings
callings113613833ca_llings
carbines123617543carb_ines
cardings123812643car_dings
carlines103521653car_lines
carling103727063car_ling_
carlins93921923car_lin_s
caroling113317003caroling_
carpings133812393car_pings
carvings143810213car_vings
catlings113712043ca_tlings
corbelings1544073corbelings
curbings13407313curb_ings
curlings114110383cur_lings
cymblings1942663cymblings
dabbling14227973dabbling_
darings93713653dar__ings
darkling1437483darkling_
darling93418363dar_ling_
darnings10378553dar_nings
dartling1039563dartling_
eanlings9128473ea_nlings
earings84517713ear__ings
earnings9419333ear_nings
earrings9299633ear_rings
earthlings1443613earthlings
fabling133413623fa_bling_
failings123811013fa_ilings
farmings14298223far_mings
farthings1635233farthings
fatlings12359303fa_tlings
gabbling14238073gabbling_
gabling113514543ga_bling_
gambling14218963gambling_
garbing113613273garb_ing_
gargling11239203gargling_
graylings1433883graylings
handlings14237343handlings
harpings14379773har_pings
hirelings1365763hirelings
hurlings12388213hur_lings
kartings13418523kar_tings
lordlings1143923lordlings
mackling172710063mackling_
maculing13219583maculing_
mailing102923343ma_iling_
mainlines1138513mainlines
makings145413163ma__kings
maligns1038133ma__ligns
malines93625603ma__lines
malling103623663ma_lling_
mamboing1535973mamboing_
mangling122312623mangling_
mantling112012613mantling_
mappings15296413ma_ppings
marbelizes2345373marbelizes
marbleises1443523marbleises
marbleizes2342943marbleizes
marblers12319233marbl_ers
marbles114516653marbl__es
marblier1256343marbli_er
marbliest1336763marbliest
marching164312193marching_
margins103815193mar_gin_s
marinas93519393mar__inas
marines93928013mar__ines
marketings1743163marketings
marking144020133mar_king_
marlin84220903mar_lin__
marline93320953mar_lin_e
marlites103415263mar_lites
marring103319553mar_ring_
marrying14157233marrying_
marting103325013mar_ting_
martinis103311613mar_tinis
martins93322063mar_tin_s
marveling1537103marveling_
maskings15448753ma_skings
matings104516213ma__tings
mattings11369673ma_ttings
mauling103315683ma_uling_
mayings134410513ma__yings
merlins93015813mer_lin_s
middlings14194313middlings
millings113712583m_illings
modelings1335563modelings
mornings11297923mor_nings
morphings1744683morphings
mumbling15198533mumbling_
nurslings1043733nurslings
paddlings14224363paddlings
palings103915823pa__lings
panelings12107453panelings
parawings1535823parawings
pargings123410163par_gings
parings104219213par__ings
parkings153610683par_kings
parling103823763par_ling_
paroling113316213paroling_
partings113513733par_tings
purflings1554093purflings
purlings113910283pur_lings
rabbling13239333rabbling_
railings93412153ra_ilings
rambling131810773rambling_
rattlings10235513rattlings
ravelings13377383ravelings
rulings83310383__rulings
rumblings14184633rumblings
sailings93513253sa_ilings
samplings1435553samplings
sandlings11238093sandlings
saplings11269803sa_plings
siblings11108123_siblings
sparlings12257153spar_lings
stablings12256103stablings
starlings10237923star_lings
tabling103216033ta_bling_
tacklings16235853tacklings
tailings93211673ta_ilings
tumblings14184843tumblings
turtlings10184873turtlings
wabbling16207743wabbling_
wafflings1943023wafflings
wambling16198443wambling_
warnings12358453war_nings
warsling12198593warsling_
yearlings1384203year_lings

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.423422437.4
2DLD Change Limit1486411616.78021923.5
3Display Results1611610.0632555.6
 (SQL Overall)1786911617.26624592.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.