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

135 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
aidful105707(None) 
aimful1166701aimful
armful1167162armful
artful968272artful
awful1178142a_wful
fitful1256332fitful
gainful1145832gainful
handful14127252handful
mindful1344612mindful
pailful1236102pailful
painful1246402painful
sinful938802sinful
tinful938042tinful
wailful1344952wailful
wilful1235962wilful
adieu6417423adieu_
adieus739633adieus
adieux1444283adieux
adult63520653a_d_ult
afoul8510193a_foul
aid49269083aid___
aide56045003aid__e
aided75828933aid_ed
aider65431133aid_er
aiders74524633aiders
aides65336603aid_es
aiding84423613aiding
aidman92410623aidman
aidmen92610373aidmen
aids57846363aid__s
ail37171043ai___l
aimfully1644063aimfully
airbus848343airbus
airfoil1044463airfoil
aldol61212333ald_ol
amidol9489573amid_ol
ampul91110853a_mpul
annul55813383a_nnul
ardour74110903ardour
armfuls1275013armfuls
armsful1284093armsful
audial7312993audial
bagful1237213bagful
bagsful1344893bagsful
baleful1238003baleful
baneful1237893baneful
bashful1556553bashful
basinful1343233basinful
biofuel1243293biofuel
boxful18145273boxful
brimful1443883brimful
cageful1356483cageful
canful11610263canful
cansful1236833cansful
capful1368173capful
careful1249113careful
carful11610973carful
cupful1356423cupful
dareful1157053dareful
direful1156613direful
dishful1455433dishful
earful958963earful
easeful1037293easeful
eyeful1235903eyeful
factful1536373factful
faithful1743383faithful
fateful1397513fateful
fistful1365903fistful
handfuls15115753handfuls
handsful1544083handsful
harmful1535763harmful
hateful13107683hateful
hatful12108743hatful
hatsful13106193hatsful
headful1445563headful
heedful1444313heedful
ideal65716393_ideal
idol56818633_id_ol
idyl85912303_id_yl
idyll9436713_idyll
ireful948713ireful
jarful1646683jarful
jarsful1744603jarsful
joyful1943843joyful
jugful1734603jugful
kistful1465303kistful
lapful1156483lapful
lawful1235493lawful
lifeful1344613lifeful
manful11610213manful
miaul71612123mi_aul
midcult1246303midcult
midgut103510053midgut
mugful1235403mugful
needful1143863needful
nidal65217103nid_al
nidus65913573nid_us
oidium959813oidium
pageful1346353pageful
pailfuls1343843pailfuls
pailsful1343263pailsful
palmful1445053palmful
panful1179743panful
picul95015363pi_cul
pipeful1445643pipeful
pitiful1245863pitiful
potful1138083potful
prideful1443913prideful
rackful1645873rackful
ridgel8399973ridgel
ridgil8316823ridgil
rueful948203rueful
sackful1645353sackful
siddur834573siddur
skilful1443933skilful
skinful1444193skinful
sobful1136333sobful
tactful1236163tactful
tankful1445163tankful
tidal64516443tid_al
tinfuls1036593tinfuls
toilful1044813toilful
topful1136543topful
trainful1145183trainful
tubful1136683tubful
useful947013useful
vatful12107083vatful
waeful1238123waeful
wakeful1735613wakeful
wameful1535673wameful
willful1344533willful
wishful1664503wishful
wistful1365713wistful
woeful1236363woeful
woful1158173_woful

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 Filter1786911127160.420425454.8
2DLD Change Limit1127161356.89016359.4
3Display Results1351350.0462934.8
 (SQL Overall)1786911357.35624291.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.