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

158 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
umbelled133627(None) 
umbeled12208191umbe_led
umbellet1247071umbellet
belled94626182__belled
gabelled12317582gabelled
impelled1336072impelled
labelled11278292labelled
libelled11317212libelled
melled95023022_m_elled
pummelled1643072pummelled
rebelled113110322rebelled
smelled103511852sm_elled
umbellar1243642umbellar
umbellets1343342umbellets
umbered121510112umbe_red
umbrellaed1551502umbrellaed
unbelted1179332unbelted
unbilled1188692unbilled
upwelled1434662upwelled
ambled115116373amb__led
balled94926893__balled
belied95022163__belied
belle75827833__belle_
belles85325993__belles
bellied104314073__bellied
belted94020633__belted
bevelled14327793bevelled
billed94224903__billed
bolled94722653__bolled
bowelled1446173bowelled
bulled94626493__bulled
bumbled144113043bumb__led
bushelled1543973bushelled
caballed1337163caballed
celled94420323__celled
compelled1646133compelled
corbelled1446613corbelled
cudgelled1443113cudgelled
cumbered15157963cumbe_red
cupelled1365743cupelled
dowelled1356343dowelled
duelled9359753_duelled
dwelled12337593_dwelled
embalmed1544263embalmed
embedded1553313embedded
embezzled2241733embezzled
emblemed1544273emblemed
embowelled1852103embowelled
excelled18125693excelled
expelled1895873expelled
felled103720303__felled
fuelled11369193_fuelled
fumbled153710493fumb__led
funnelled1374233funnelled
gabelle10259213gabelle_
gabelles11278933gabelles
gambolled1543103gambolled
gavelled13387363gavelled
gelled84718893__gelled
gimballed1542673gimballed
gruelled1034893gruelled
helled104024703__helled
hovelled15146843hovelled
humbled153711813humb__led
imbalmed1543293imbalmed
imbedded1542863imbedded
impeller1236083impeller
jelled144916063__jelled
jewelled1934333jewelled
jumbled19379963jumb__led
knelled12338993_knelled
kvelled15276063_kvelled
labeled102510563labe_led
labeller10248073labeller
lapelled11227083lapelled
levelled12327443levelled
libeled10249413libe_led
libellee10227733libellee
libeller10297433libeller
lumbered13188233lumbe_red
malled94626113_m_alled
melded104714713_m_elded
melted94219063_m_elted
mewled123710053_m_ewled
milled94326173_m_illed
modelled1236433modelled
mulled94721553_m_ulled
mumbled143010763mumb__led
muralled1136423muralled
numbered13147143numbe_red
outyelled1345313outyelled
panelled1138963panelled
pommelled1643083pommelled
pummeled1543373pumme_led
quelled17279273_quelled
ravelled12419783ravelled
rebilled11318053rebilled
refelled122810163refelled
repelled113111583repelled
revelled123712733revelled
rowelled1236633rowelled
rumbled124514593rumb__led
shelled113815083_shelled
smeller94212783sm_eller
smelted10399093sm_elted
snelled83313043_snelled
spelled103714733_spelled
swelled113211693_swelled
symbolled1742823symbolled
timbrelled1542253timbrelled
towelled1236353towelled
tumbled123412243tumb__led
tunnelled1054583tunnelled
umbel93612843umbe_l__
umbellate1343973umbellate
umbellifer1751813umbellifer
umbellule1351993umbellule
umbellules1451843umbellules
umbels104510593umbe_l_s
umbles103817493umb__les
umbrella1243273umbrell_a
umbrellas1343093umbrellas
unbaled103315963unb_aled
unbeared111611653unbeared
unbelief1346773unbelief
unbeloved1543923unbeloved
unbended12279973unbended
unboiled112410373unboiled
unbolted1179323unbolted
uncalled11810923uncalled
undulled1036993undulled
unfelted1279403unfelted
unfilled1298383unfilled
ungalled1078463ungalled
ungelded1147403ungelded
unhealed121511073unhealed
unhelmed1435993unhelmed
unhelped1435923unhelped
unkeeled13117183unkeeled
unmelted1169183unmelted
unmilled1197853unmilled
unpeeled11118533unpeeled
unpolled1168943unpolled
unquelled1944413unquelled
unreeled91310333unreeled
unrolled9610413unrolled
unsealed91513623unsealed
unshelled1336563unshelled
untilled9710563untilled
unveiled1298163unveiled
unwalled1288653unwalled
unwelded1337143unwelded
unwilled1277823unwilled
upboiled13194853upboiled
upswelled1542893upswelled
welled103820213__welled
yelled104116253__yelled
yodelled1334603yodelled

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.423422437.4
2DLD Change Limit1461621586.26323337.4
3Display Results1581580.0632507.9
 (SQL Overall)1786911586.74926476.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.