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

140 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
aimful116670(None) 
aidful1057071aidful
armful1167161armful
aimfully1644062aimfully
ampul91110852a_mpul
armfuls1275012armfuls
armsful1284092armsful
artful968272artful
awful1178142a_wful
brimful1443882brimful
fitful1256332fitful
gainful1145832gainful
harmful1535762harmful
pailful1236102pailful
painful1246402painful
palmful1445052palmful
sinful938802sinful
tinful938042tinful
wailful1344952wailful
wilful1235962wilful
afoul8510193a_foul
ail37171043ai___l
aim57858213aim___
aimed85626053aim_ed
aimer75926823aim_er
aimers84621913aimers
aiming94320843aiming
aims67738183aim__s
airbus848343airbus
airfoil1044463airfoil
airmail946213airmail
almud84012183alm_ud
almug8429303alm_ug
amicus103810003amicus
amidol9489573amidol
amour75014853a_mour
ampule10710613a_mpule
ampuls1098893a_mpuls
amu58237323a_m_u_
amus65529613a_m_us
amyl95515103a_m_yl
animal85016253anim_al
animus84211613anim_us
annul55813383a_nnul
armour84411853armour
awmous1157713awmous
bagful1237213bagful
bagsful1344893bagsful
baleful1238003baleful
baneful1237893baneful
bashful1556553bashful
basinful1343233basinful
biofuel1243293biofuel
boxful18145273boxful
brimfull1542543brimfull
cageful1356483cageful
canful11610263canful
cansful1236833cansful
capful1368173capful
careful1249113careful
carful11610973carful
cupful1356423cupful
dareful1157053dareful
dimout9414243dimout
direful1156613direful
dishful1455433dishful
doomful1343663doomful
earful958963earful
easeful1037293easeful
eyeful1235903eyeful
factful1536373factful
faithful1743383faithful
fateful1397513fateful
fistful1365903fistful
formful1545183formful
gimbal11228813gimbal
gimel8313353gim_el
gimmal11247513gimmal
hamaul114210873hamaul
handful14127253handful
hateful13107683hateful
hatful12108743hatful
hatsful13106193hatsful
iambus10468903iambus
imaum9139643_imaum
imbue939483_imbue
impel95711773_impel
ireful948713ireful
jarful1646683jarful
jarsful1744603jarsful
joyful1943843joyful
jugful1734603jugful
kistful1465303kistful
lapful1156483lapful
lawful1235493lawful
lifeful1344613lifeful
limbus105710383limbus
limuli836343lim_uli
manful11610213manful
maul64830723__maul
miaul71612123mi_aul
mindful1344613mindful
mugful1235403mugful
nimbus10377283nimbus
pageful1346353pageful
pailfuls1343843pailfuls
pailsful1343263pailsful
palmfuls1543473palmfuls
panful1179743panful
picul95015363pi_cul
pipeful1445643pipeful
pitiful1245863pitiful
potful1138083potful
rackful1645873rackful
rimous8311913rimous
roomful1244183roomful
rueful948203rueful
sackful1645353sackful
simnel857023simnel
skilful1443933skilful
skinful1444193skinful
sobful1136333sobful
tactful1236163tactful
tankful1445163tankful
timbal102510753timbal
tinfuls1036593tinfuls
toilful1044813toilful
topful1136543topful
trainful1145183trainful
tubful1136683tubful
useful947013useful
vatful12107083vatful
waeful1238123waeful
wakeful1735613wakeful
wameful1535673wameful
willful1344533willful
wishful1664503wishful
wistful1365713wistful
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.390458182.1
2DLD Change Limit1127161406.17318259.5
3Display Results1401400.0463043.5
 (SQL Overall)1786911406.60927037.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.