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

115 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
bashful155655(None) 
bagful1237212ba_gful
bagsful1344892bagsful
baleful1238002baleful
baneful1237892baneful
bashfully2043842bashfully
basinful1343232basinful
blushful1643182blushful
boastful1344852boastful
dishful1455432dishful
easeful1037292easeful
hushful1644332hushful
pushful1544492pushful
wishful1664502wishful
aidful1057073_aidful
aimful1166703_aimful
armful1167163_armful
artful968273_artful
ashfall1343943_ashfall
awful1178143_a_wful
babul96317713ba__bul
backhaul1945133backhaul
bagfuls1334753ba_gfuls
basal75722283bas__al
bascule1136573bas_cule
bash915240163bash___
bashaw14349303bash_aw
bashaws15347713bashaws
bashed126225703bash_ed
basher115123813bash_er
bashers124820833bashers
bashes115631393bash_es
bashing135422583bashing
bashlyk1942463bashlyk
basify1437513basif_y
basil75122273bas__il
basinal9310033basinal
basinfuls1442303basinfuls
basketful1852133basketful
basque17259083bas_que
bathtub1442693bathtub
bathyal1544823bathyal
beshout12311833beshout
blameful1543813blameful
blissful1342543blissful
boatful1236283boatful
bookful1644773bookful
bowlful1544613bowlful
boxful18145273b_oxful
boxhaul1943013boxhaul
brimful1443883brimful
bushel114513943bush_el
cageful1356483cageful
canful11610263ca_nful
cansful1236833cansful
capful1368173ca_pful
careful1249113careful
carful11610973ca_rful
dareful1157053dareful
deathful1544013deathful
dishfuls1554313dishfuls
earful958963ea_rful
factful1536373factful
faithful1743383faithful
fateful1397513fateful
feastful1444923feastful
fistful1365903fistful
gainful1145833gainful
ghastful1543303ghastful
glassful12113563glassful
handful14127253handful
harmful1535763harmful
hasteful14105253hasteful
hateful13107683hateful
hatful12108743ha_tful
hatsful13106193hatsful
jarful1646683ja_rful
jarsful1744603jarsful
jestful1745333jestful
kashrut1444913kashrut
kistful1465303kistful
lapful1156483la_pful
lawful1235493la_wful
loathful1443383loathful
lustful1045283lustful
manful11610213ma_nful
museful1245883museful
pageful1346353pageful
pailful1236103pailful
painful1246403painful
palmful1445053palmful
panful1179743pa_nful
rackful1645873rackful
restful1038623restful
ruthful1344503ruthful
sackful1645353sackful
shaul85418103__shaul
shul75823153__sh_ul
tactful1236163tactful
tankful1445163tankful
tasteful11115223tasteful
useful947013_useful
vatful12107083va_tful
waeful1238123wa_eful
wailful1344953wailful
wakeful1735613wakeful
wameful1535673wameful
washout13410133washout
washtub1542463washtub
washup1435323wash_up
wasteful14104933wasteful
watchful1943753watchful
wistful1365713wistful
wrathful1743613wrathful
zestful1945243zestful

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 Filter1786911340270.393454684.5
2DLD Change Limit1340271156.37321030.4
3Display Results1151150.0462500.0
 (SQL Overall)1786911156.81226231.8
 
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.