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

145 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
jewelled193433(None) 
jeweled1845331jewe_led
jeweller1844121jeweller
bejewelled2351462bejewelled
bevelled14327792bevelled
bowelled1446172bowelled
dowelled1356342dowelled
dwelled12337592_dwelled
jelled144916062j__elled
jeweler1735052jewe_ler
jewellers1943532jewellers
jewellery2241822jewellery
jewelweed2341422jewelweed
levelled12327442levelled
rebelled113110322rebelled
refelled122810162refelled
repelled113111582repelled
revelled123712732revelled
rewelded1335892rewelded
rowelled1236632rowelled
swelled113211692_swelled
towelled1236352towelled
upwelled1434662upwelled
welled103820212__welled
beetled1038213be_etled
begalled1236023begalled
bejeweled2272003bejewe_led
belled94626183__belled
beveled133811123beve_led
beveller13387663beveller
bewailed1435343bewailed
boweled132810693bowe_led
celled94420323__celled
crenelled1245403crenelled
cupelled1365743cupelled
defuelled1443123defuelled
develed123611933deve_led
devilled1336743devilled
dewooled1333833dewooled
doweled12269773dowe_led
duelled9359753_duelled
dweller11297273_dweller
excelled18125693excelled
expelled1895873expelled
farewelled1742373farewelled
felled103720303__felled
ferrelled1343933ferrelled
fuelled11369193_fuelled
gabelled12317583gabelled
gavelled13387363gavelled
gelled84718893__gelled
gruelled1034893gruelled
heeled104018413he_e_led
helled104024703__helled
hovelled15146843hovelled
impelled1336073impelled
inwalled1275773inwalled
jeeped16469843je_e_ped
jeered143912793je_e_red
jellied15419223je_llied
jereed144012073jere__ed
jewed165114833jew___ed
jewel156711703jewe_l__
jewelers1834713jewelers
jeweling1935483jeweling
jewellike2342243jewellike
jewelling2034833jewelling
jewelries1943033jewelries
jewelry2041993jewe_lry
jewels16508613jewe_l_s
jewelweeds2451153jewelweeds
jowled174210803jow__led
keeled114414273ke_e_led
kennelled1443503kennelled
kernelled1443733kernelled
knelled12338993_knelled
kvelled15276063_kvelled
labelled11278293labelled
lapelled11227083lapelled
leveled114010383leve_led
leveller11317593leveller
libelled11317213libelled
medalled1246893medalled
melled95023023__melled
metalled1148983metalled
mewled123710053mew__led
modelled1236433modelled
needled9358513ne_edled
panelled1138963panelled
pedalled1246933pedalled
peeled94119713pe_e_led
perilled11410113perilled
petalled1138703petalled
quelled17279273_quelled
ravelled12419783ravelled
rebilled11318053rebilled
recalled11310803recalled
reeled74725533re_e_led
refilled12278673refilled
refuelled1364503refuelled
reheeled1236773reheeled
remelted11310153remelted
repealed113211873repealed
repeller103010393repeller
repolled11359623repolled
rerolled93010053rerolled
resealed92713963resealed
reseller83412223reseller
respelled1257043respelled
revealed123211213revealed
reveled113917753reve_led
reveller112912183reveller
reweaved1535953reweaved
rewedded1434513rewedded
reweld103711113rewe_l_d
rewetted12228353rewetted
roweled11269863rowe_led
seeled73922093se_e_led
sepalled1156903sepalled
sewered112911243sewe_red
shelled113815083_shelled
smelled103511853_smelled
snelled83313043_snelled
spelled103714733_spelled
sweller103012463_sweller
swilled113611833_swilled
teaselled1045123teaselled
teazelled1943733teazelled
toweled112410223towe_led
trowelled1344443trowelled
tweedled1332833tweedled
twilled11398033_twilled
umbelled1336273umbelled
unwalled1288653unwalled
unwelded1337143unwelded
unwilled1277823unwilled
upswelled1542893upswelled
walled104021293__walled
weaselled1344183weaselled
wedeled1237783wede_led
welded114013383__welded
welted103715823__welted
willed104722453__willed
yelled104116253__yelled
yodelled1334603yodelled

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621456.72021750.3
3Display Results1451450.0602416.7
 (SQL Overall)1786911457.20024818.2
 
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.