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

107 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
piously123683(None) 
copiously1646742copiously
impiously1645822impiously
odiously1245422odiously
pious74621272pious__
piteously1446312piteously
porously1347752porously
proudly1336332proudly
vinously1445282vinously
anxiously1945863anxiously
bihourly1663063bihourly
biliously1446663biliously
biopsy1334533biops_y
blousily1345193blousily
blousy11459123blous_y
bogusly1343893bogusly
bousy104917843_bous_y
captiously1746103captiously
crossly1277273crossly
crousely1346563crousely
curiously1447673curiously
deviously1645513deviously
doubly12328963_doubly
dourly103210433_dourly
dubiously1545293dubiously
enviously1545893enviously
famously1685133famously
fibrously1744953fibrously
foully1239013_foully
furiously1546503furiously
gibbously1772923gibbously
grossly1175983grossly
heinously1544773heinously
hideously1644703hideously
hourly12369623_hourly
joyously2143293joyously
leprously1445323leprously
loudly1037783_loudly
lousily1038333_lousily
lousy84617083_lous_y
mousey115216193_mousey
mousily1239393_mousily
mousy106716943_mous_y
noxiously1945463noxiously
obviously1744773obviously
ominously1445523ominously
parlously1445663parlously
perilously1546433perilously
phonily1537103phonily
picul95015363picu_l_
piculs103511753picu_ls
piddly13319143pi_ddly
pigsty1235933pi_gsty
pilous84717753pilous__
pilule8411123pilu_le
pilus75921063pilus__
pily96132733pi___ly
pimply15329213pi_mply
pinkly155012243pi_nkly
pions75826393pions__
piosity1268643piosity
pithily1567033pithily
plushly15385383p_lushly
plushy14406973p_lushy
poesy105014063p_oes_y
pokily15309063p_okily
poly96235153p_o__ly
pompously1844353pompously
poorly1137893p_oorly
popsy125713403p_ops_y
portly114713403p_ortly
poshly1437723p_oshly
posy96028423p_o_s_y
potsy105815613p_ots_y
pouchy16538663p_ouchy
pouffy17395883p_ouffy
poult76928873p_ou_lt
pouty107018813p_ou_ty
preciously1746983preciously
previously1885863previously
priorly12335763prio_rly
profusely1743063profusely
pronely12310253pronely
prosily12611633prosily
prosy106319253pro_s_y
pushy134614353p__ushy
pusley11379613p__usley
pussly11407373p_ussly
pussy105614843p__ussy
riotously1245703riotously
ruinously1245733ruinously
seriously1248383seriously
sinuously1245583sinuously
sourly93612213_sourly
spaciously1746403spaciously
speciously1746343speciously
spuriously1545893spuriously
stoutly1035833stoutly
tediously1345873tediously
thusly1235133_thusly
timeously1445393timeously
tousle64514653_tousle
variously1547313variously
venously1445663venously
viciously1746393viciously
villously1544533villously
viscously1744853viscously

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.406440125.6
2DLD Change Limit1340271077.11318842.5
3Display Results1071070.0432488.4
 (SQL Overall)1786911077.56223630.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.