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 “fearful” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

93 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
fearful134559(None) 
earful958961_earful
tearful1046031tearful
carful11610972_carful
earfuls1036862_earfuls
farfal123410182f_arfal
farfel124310432f_arfel
fearfully1843892fearfully
feastful1444922feastful
headful1445562headful
jarful1646682_jarful
unfearful1552302unfearful
weariful1443572weariful
armful1167163__armful
artful968273__artful
awful1178143__awful
bagful1237213_bagful
bearhug1343163bearhug
boatful1236283boatful
canful11610263_canful
capful1368173_capful
careful1249113_careful
carfuls1249133_carfuls
cheerful1643983cheerful
dareful1157053_dareful
deathful1544013deathful
dreadful1343223dreadful
dreamful1452963dreamful
earbud936283_earbud
earl45838143_ear__l
easeful1037293_easeful
eyeful1235903_eyeful
factful1536373factful
fardel104712593f_ardel
farfals13268503f_arfals
farfels13348213f_arfels
farl76338553f_ar__l
fateful1397513fateful
feal713940423fea___l
fear75337793fear___
feared106320433fear_ed
fearer94820183fear_er
fearers104815273fearers
fearfuller1651803fearfuller
fearing113520033fearing
fears84829393fear__s
felafel1333723felafel
feral85424653fe_r_al
ferial94621253fe_rial
ferrel92810203fe_rrel
ferrous1049803ferrous
ferrule1035863fe_rrule
ferrum1147453fe_rrum
ferula93011173fe_r_ula
ferule93413203fe_r_ule
fistful1365903fistful
fitful1256333f_itful
flareup1243173flareup
flavorful1851713flavorful
forkful1744773forkful
formful1545183formful
fretful1346143fretful
furfur1235553f_urfur
harmful1535763_harmful
hatful12108743_hatful
headfuls1544313headfuls
heedful1444313heedful
helpful1543963helpful
jarfuls1754773_jarfuls
jarsful1744603_jarsful
jestful1745333jestful
lapful1156483_lapful
lawful1235493_lawful
manful11610213_manful
moanful12105003moanful
needful1143863needful
odorful1143483odorful
panful1179743_panful
peaceful1545463peaceful
pearl75324463pear__l
playful1544653playful
reargue836463reargue
regardful1451933regardful
restful1038623restful
sneerful1143553sneerful
swayful1643003swayful
tearfully1544143tearfully
teenful1045563teenful
trayful1344583trayful
unartful1153563unartful
vatful12107083_vatful
waeful1238123_waeful
zestful1945243zestful

Search took 9 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.423422437.4
2DLD Change Limit134027937.53017799.1
3Display Results93930.0303100.0
 (SQL Overall)178691937.98322383.9
 
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.