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

162 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
armful116716(None) 
aimful1166701aimful
armfuls1275011armfuls
armsful1284091armsful
artful968271artful
harmful1535761harmful
aidful1057072aidful
ampul91110852a_mpul
armour84411852armour
awful1178142a_wful
brimful1443882brimful
careful1249112careful
carful11610972car_ful
dareful1157052dareful
earful958962ear_ful
formful1545182formful
ireful948712ireful
jarful1646682jar_ful
jarsful1744602jarsful
palmful1445052palmful
afoul8510193a_foul
aimfully1644063aimfully
airmail946213airmail
almud84012183alm_ud
almug8429303alm_ug
amour75014853a_mour
ampule10710613a_mpule
ampuls1098893a_mpuls
amu58237323a_m_u_
amus65529613a_m_us
amyl95515103a_m_yl
annul55813383a_nnul
arbour84211333arbour
archil11611573archil
arcus76918863ar_cus
ardour74110903ardour
areal55928733ar_eal
arf67453373ar_f__
arfs76029963ar_f_s
argal65023393ar_gal
argil65116883ar_gil
argol65317263ar_gol
argue64818443ar_gue
argufy1344093argufy
argus66716543ar_gus
argyll1033643argyll
ariel55228973ar_iel
aril45843023ar__il
arm58449623arm___
armada938783armada
armed86324433arm_ed
armer76924443arm_er
armers85520273armers
armet76739453arm_et
armets84918353armets
armhole1236943armhole
armies85123693armies
armilla936993armilla
arming94719803arming
armlet84118193armlet
armor75118053arm_or
armors85017813armors
armory114211473armory
armours9389853armours
armoury12376233armoury
armpit10811093armpit
arms66137493arm__s
armure8710133armure
army96624183arm__y
artal55525473ar_tal
artel56122743ar_tel
artfully1445403artfully
arugula843913arugula
arum66129033ar__um
arval86017013ar_val
aryl75922343ar__yl
awmous1157713awmous
bagful1237213bagful
bagsful1344893bagsful
baleful1238003baleful
baneful1237893baneful
bashful1556553bashful
boxful18145273boxful
brimfull1542543brimfull
cageful1356483cageful
canful11610263canful
cansful1236833cansful
capful1368173capful
caracul1138823caracul
carfuls1249133car_fuls
cupful1356423cupful
direful1156613direful
doomful1343663doomful
dreamful1452963dreamful
earfuls1036863ear_fuls
earmuff1543063earmuff
easeful1037293easeful
eyeful1235903eyeful
factful1536373factful
farfal123410183far_fal
farfel124310433far_fel
fateful1397513fateful
fearful1345593fear_ful
fitful1256333fitful
forkful1744773forkful
fretful1346143fretful
gainful1145833gainful
hamaul114210873hamaul
handful14127253handful
harmfully2043333harmfully
hateful13107683hateful
hatful12108743hatful
hatsful13106193hatsful
hurtful1344853hurtful
jarfuls1754773jar_fuls
joyful1943843joyful
jugful1734603jugful
karakul1042553karakul
lapful1156483lapful
lawful1235493lawful
manful11610213manful
maul64830723__maul
mugful1235403mugful
ormolu845833ormolu
pageful1346353pageful
pailful1236103pailful
painful1246403painful
palmfuls1543473palmfuls
panful1179743panful
potful1138083potful
rackful1645873rackful
ramal74622243ram_al
ramous8417113ramous
ramtil8311033ramtil
ramus76418283ram_us
refel84920813_refel
refuel93912623_refuel
roomful1244183roomful
rueful948203rueful
sackful1645353sackful
sinful938803sinful
sobful1136333sobful
tactful1236163tactful
tankful1445163tankful
tearful1046033tear_ful
tinful938043tinful
topful1136543topful
trayful1344583trayful
tubful1136683tubful
unartful1153563unartful
unharmful1751553unharmful
useful947013useful
vatful12107083vatful
waeful1238123waeful
wailful1344953wailful
wakeful1735613wakeful
wameful1535673wameful
warmup1335343warm_up
weariful1443573weariful
wilful1235963wilful
woeful1236363woeful
woful1158173_woful

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 Filter1786911127160.376475242.0
2DLD Change Limit1127161625.60620106.3
3Display Results1621620.0632571.4
 (SQL Overall)1786911626.04529560.1
 
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.