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

241 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
lousily103833(None) 
blousily1345191blousily
mousily1239391mousily
blowsily1643952blowsily
bossily1237562bossily
busily112211502_busily
cloudily1444282cloudily
cosily113613852co_sily
cousinly1345932cousinly
crusily12199092crusily
flossily1434522flossily
glossily1235092glossily
goutily1137932goutily
horsily1338842horsily
loftily1336352loftily
logily1039832lo_gily
loonily1037072loonily
loopily1236802loopily
loosely1036712loosely
loudly1037782lou_dly
lousier72411622lousier
lousing83817732lousing
lousy84617082lous__y
lowlily1335352lowlily
lushly12247342l_ushly
lustily103611242l_ustily
noisily1038402noisily
nosily93712682no_sily
rosily93914712ro_sily
roupily1246652roupily
bloodily1445183bloodily
blousier1055663blousier
blousing1138793blousing
blousy11459123blous__y
blowzily2542733blowzily
bodily12310993bo_dily
bogusly1343893bogus_ly
bonnily1236873bonnily
boozily2135623boozily
bouncily1544383bouncily
bousing103718043bousing
bousy104917843bous__y
boxily1877843bo_xily
bushily15268893_bushily
classily1336623classily
cloggily1543243cloggily
closely1237053clo_sely
clumsily1544003clumsily
cockily1838493cockily
cornily12410853cornily
costly114012333co_stly
courtly1256913courtly
cousin8517153cousi_n
cousinry1343533cousinry
cousins9516003cousins
cozily20349703co_zily
croupily1544743croupily
crousely1346563crousely
crustily13328173crustily
cushily15257923_cushily
doily95321033do__ily
doomily1336133doomily
dopily123510463do_pily
dossil75110903dossil_
dossils8669773dossils
dottily1147283dottily
doubly12328963dou_bly
doucely1344883doucely
dourly103210433dou_rly
dousing93315763dousing
dowdily1534953dowdily
dozily19329103do_zily
drowsily1583723drowsily
duskily15236743_duskily
dustily113211523_dustily
easily9313023_easily
flimsily1643283flimsily
floppily1843773floppily
flukily1735213flukily
foamily1546543foamily
foggily1535053foggily
folksily1843443folksily
fossil9379353fossil_
fossils10379013fossils
foully1239013fou_lly
foxily1947253fo_xily
fusibly1535863_fusibly
fusil84715323_fusil_
fusile94313493_fusile
fusils93912343_fusils
fussily13267603fussily
fustily133111373_fustily
gassily1137813gassily
gaudily1236523gaudily
gauzily2034393gauzily
glassily1235463glassily
gloomily1443753gloomily
gluily10308293glu_ily
godlily1235343godlily
goofily14105353goofily
gorily10612503go_rily
gossipy1343953gossipy
gushily14257823_gushily
gustily113010903_gustily
gutsily11267223gutsily
hoarily1338973hoarily
hokily16409093ho_kily
holily123612953ho_lily
homily144712333ho_mily
hornily1338283hornily
hostly124210863ho_stly
hourly12369623hou_rly
housefly1744103housefly
housel95217043housel_
housels105312133housels
housing113316523housing
huskily17236333_huskily
jokily20306533jo_kily
jollily1745773jollily
joltily1746323joltily
justly16307253_justly
lacily11612763l_acily
lankily1437123lankily
lastly93310873l_astly
lazily1859713l_azily
leakily1436473leakily
leerily1037633leerily
lily76730183l___ily
loathly1334713loathly
locally12179723locally
lolly85120663lo__lly
lonelily1144973lonelily
lonely92912473lo_nely
longly10279603lo_ngly
loosing83515963loosing
lordly1038753lo_rdly
losel54419423lo_sel_
losels64714583lo_sels
losing74022873lo_sing
losingly1236393lo_singly
lossy85214643lo_s_sy
loudish1137983loudish
louie55023513lou_i_e
louies64525103lou_ies
louis57322323lou_i_s
loungy10476833lou_ngy
louping104313983louping
louring83916503louring
loury85716753lou__ry
louse56131013lous__e
loused74822913lous_ed
louses66230283lous_es
lousiest82311613lousiest
louting83719383louting
loutish1039963loutish
loutishly1543743loutishly
lovably15187063lovably
lovelily1444333lovelily
lovely12339713lo_vely
loverly1346973loverly
lowly114113333lo__wly
loyally13126843loyally
lucidly13125213l_ucidly
luckily16297083luckily
lumpily1476563lumpily
luridly1196283l_uridly
lusty85417573l_us_ty
messily12298813messily
moistly1236613moistly
moodily1358203moodily
moonily1248943moonily
mostly113110943mo_stly
mousey115216193mous_ey
mousier93712463mousier
mousing103816273mousing
mousy106716943mous__y
mouthily1645903mouthily
muscly1337453_muscly
mushily152410093_mushily
muskily16289043_muskily
mussily12279773mussily
mustily123613633_mustily
nobbily1436693nobbily
noily86120993no__ily
nonoily1049543nonoily
oilily93111723_oilily
oily77932253_o__ily
oozily18328073_oozily
ossify1244973_ossify
ousel55222403_ousel_
ousels64815273_ousels
outfly1238273_outfly
piously1236833pious_ly
plausibly1643113plausibly
plushily1664423plushily
plushly15385383plushly
pockily1846233pockily
podgily1435213podgily
pokily15309063po_kily
poshly1437723po_shly
possibly1544483possibly
prosily12611633prosily
punily11311773_punily
pursily1238213pursily
pushily15247983_pushily
pussly11407373_pussly
robustly1342763robustly
roily86121113ro__ily
roomily1237283roomily
ropily113312443ro_pily
rosiny94414533ro_siny
roughly14507293roughly
roundly1136723roundly
rousing83920553rousing
rousingly1335773rousingly
rowdily1436083rowdily
rustily103112993_rustily
sassily1038723sassily
saucily1237913saucily
sloppily1544613sloppily
slouchily1742683slouchily
slushily1445013slushily
soapily1237963soapily
soggily1235953soggily
sootily101810513sootily
sorrily1039823sorrily
soundly1136683soundly
sourly93612203sou_rly
sousing83517823sousing
souslik1144153souslik
thusly1235133thus_ly
tipsily1236043tipsily
tonsil6311873tonsil_
tonsils7310183tonsils
touchily1645233touchily
toughly14487433toughly
tousing82916993tousing
tousle64514653tous_le
trustily11257103trustily
woozily2234383woozily
wordily1437853wordily

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 Filter1786911340270.1431249587.4
2DLD Change Limit1340272417.62317581.9
3Display Results2412410.0932591.4
 (SQL Overall)1786912417.85922737.1
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.