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

125 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
dareful115705(None) 
careful1249111careful
direful1156611direful
armful1167162_armful
artful968272_artful
baleful1238002baleful
baneful1237892baneful
cageful1356482cageful
carful11610972car_ful
dirgeful1343252dirgeful
doleful1146332doleful
earful958962ear_ful
easeful1037292easeful
fateful1397512fateful
harmful1535762harmful
hateful13107682hateful
ireful948712_ireful
jarful1646682jar_ful
jarsful1744602jarsful
pageful1346352pageful
waeful1238122wa_eful
wakeful1735612wakeful
wameful1535672wameful
adrenal838263adrenal
aidful1057073_aidful
aimful1166703_aimful
areal55928733_are_al
armfuls1275013_armfuls
armsful1284093_armsful
awful1178143_a_wful
bagful1237213ba_gful
bagsful1344893bagsful
barefit1249723barefit
barrelful1442313barrelful
bashful1556553bashful
blameful1543813blameful
cagefuls1484343cagefuls
canful11610263ca_nful
cansful1236833cansful
capful1368173ca_pful
caracul1138823caracul
carefully1745083carefully
carfuls1249133car_fuls
daedal849083da_edal
dare55848863dare___
dared75935013dare__d
darer65230793dare__r
darers75921873dare_rs
dares66146703dare__s
daresay1135433daresay
darnel74312183dar_nel
deathful1544013deathful
defuel10348933d__efuel
direfully1644783direfully
dishful1455433dishful
doomful1343663doomful
drawerful1651973drawerful
dreadful1343223d_readful
dreamful1452963d_reamful
dreidl835233d_reidl
dutiful1144763dutiful
earfuls1036863ear_fuls
eyeful1235903_eyeful
factful1536373factful
farfal123410183far_fal
farfel124310433far_fel
fearful1345593fear_ful
forceful1644603forceful
forkful1744773forkful
formful1545183formful
fretful1346143_fretful
gainful1145833gainful
gardenful1442353gardenful
gleeful1144323gleeful
graceful1445393graceful
grateful1245403grateful
handful14127253handful
hasteful14105253hasteful
hatful12108743ha_tful
hatsful13106193hatsful
hopeful1545913hopeful
hurtful1344853hurtful
jarfuls1754773jar_fuls
karakul1042553karakul
ladleful1243283ladleful
lapful1156483la_pful
lawful1235493la_wful
lifeful1344613lifeful
manful11610213ma_nful
museful1245893museful
odorful1143483odor_ful
pagefuls1474343pagefuls
pailful1236103pailful
painful1246403painful
palmful1445053palmful
panful1179743pa_nful
pareu74928743pare_u_
pareus85420743pare_us
peaceful1545463peaceful
pipeful1445643pipeful
plateful1345433plateful
rackful1645873rackful
rarefy12296343raref_y
refel84920813__refel
refuel93912623__refuel
rueful948203_rueful
sackful1645353sackful
shameful1644283shameful
spadeful1443963spadeful
stageful1244453stageful
tableful1344183tableful
tactful1236163tactful
tankful1445163tankful
tasteful11115223tasteful
tearful1046033tear_ful
trayful1344583trayful
tuneful1046123tuneful
unartful1153563unartful
useful947013_useful
vatful12107083va_tful
wailful1344953wailful
wamefuls1643873wamefuls
wasteful14104933wasteful
weariful1443573weariful
woeful1236363_woeful

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 Filter1786911340270.390458182.1
2DLD Change Limit1340271257.01619103.1
3Display Results1251250.0304166.7
 (SQL Overall)1786911257.43624030.5
 
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.