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

150 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
marveling153710(None) 
marvelling1645361marvelling
barreling1238042barreling
gaveling133410162ga_veling
graveling1457382graveling
marbling13179882mar_bling
marcelling1545592marcelling
marketing1636512marketing
marling103322772mar__ling
morseling1238072morseling
parceling1438442parceling
raveling123414372ra_veling
starveling1444262starveling
traveling1349052traveling
aneling82719503_a_neling
angeling102811733_angeling
anviling1239743_anviling
argling92812733_ar_gling
atheling1249203_atheling
barbering14229693barbering
barrelling1345453barrelling
bartering122313653bartering
beveling143011033_beveling
cageling12310843ca_geling
canceling14310163canceling
careening12310013careening
careering12311203careering
carling103727063car__ling
caroling113317003car_oling
carolling1259413carolling
carpeting1439483carpeting
carving133916773carv__ing
caviling14310113ca_viling
corbeling1439033corbeling
cravening1547553cravening
creeling113513363_creeling
curveting1535353curveting
darkening1535683darkening
darkling1437483dar_kling
darling93418363dar__ling
dartling1039563dar_tling
davening13258873da_vening
develing133212733_develing
driveling1445763driveling
earthling1346193earthling
farseeing1344383farseeing
ferreling13136273ferreling
garbling12249453gar_bling
gardening1236513gardening
gargling11239203gar_gling
garnering11298093garnering
gartering112111593gartering
gavelling14286883ga_velling
gravelling1565213gravelling
groveling1435573groveling
grueling1078273_grueling
hanseling1338063hanseling
hardening1438023hardening
harkening1746923harkening
harvesting1744413harvesting
havening15258553ha_vening
havering152211053ha_vering
hireling121210993hir_eling
hirseling1396273hirseling
hoveling15189593_hoveling
javelin17306983ja_velin_
javelina18315453ja_velina
javelins18277733ja_velins
kerneling1464403kerneling
labeling11311653la_beling
laureling1035643laureling
leveling122910433_leveling
mackling172710063ma_ckling
maculing13219583ma_culing
maddening1445113maddening
mailing102923343ma__iling
malling103623663ma__lling
mammering1337333mammering
manacling1446283manacling
mangling122312623ma_ngling
mantling112012613ma_ntling
marauding1344983marauding
marbelize2246113marbelize
marbelizing2544703marbelizing
marblings14225543mar_blings
marching164312193mar_ching
margenting1446153margenting
margining1337603margining
marketings1743163marketings
marking144020133mar__king
marlin84220913mar__lin_
marline93320973mar__line
marlings113713503mar__lings
marlins93420483mar__lins
marooning1238593marooning
marring103319553mar__ring
marrowing1546663marrowing
marrying14157233mar_rying
marshaling1645083marshaling
marting103325013mar__ting
martyring1535783martyring
marvel113712003marvel___
marveled1436433marvel_ed
marvelled1544963marvelled
marvelous1444373marvelous
marvels123810093marvel__s
mastering122315313mastering
mattering122314063mattering
mauling103315683ma__uling
modeling12311073m_odeling
morselling1346323morselling
murdering1357133murdering
paneling111013623pa_neling
parcelling1546173parcelling
pargeting1338283pargeting
parleying1536113parleying
parling103823763par__ling
paroling113316213par_oling
parvolin1376933parvolin_
parvoline1477173parvoline
parvolins1486693parvolins
purveying1843573purveying
quarreling2043663quarreling
rappeling1435963rappeling
ravelin102211023ra_velin_
ravelings13377383ra_velings
ravelins113011603ra_velins
ravelling13269253ra_velling
ravening122611293ra_vening
reeling83126863__reeling
reveling123117083_reveling
shaveling1646843shaveling
shoveling1635553shoveling
shriveling1743253shriveling
smartening1344993smartening
sniveling1336033sniveling
starvelings1542223starvelings
streeling10189483streeling
surveying1644963surveying
swiveling1634573swiveling
targeting1137303targeting
tasseling1035853tasseling
trameling1249053trameling
travelling1456533travelling
unraveling1454473unraveling
unreeling1038983unreeling
warbling14198943war_bling
warsling12198593war_sling
warstling1335063warstling
wavering152410543wa_vering

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.420425454.8
2DLD Change Limit1486411506.81321817.3
3Display Results1501500.0801875.0
 (SQL Overall)1786911507.31324434.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.