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

142 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
tipsily123604(None) 
nippily1444712nippily
tidily102811392ti_dily
tinily94014432ti_nily
tinnily1047362tinnily
tipsier9268892tipsier
tipsy106010502tips__y
wispily1535652wispily
airily93014823ai_rily
apishly1535663apishly
bossily1237563bossily
busily112211503_busily
cosily113613853_cosily
crispily1574693crispily
crusily12199093crusily
dingily1238103dingily
dirtily1138583dirtily
dizzily1934843dizzily
dopily123510463dop_ily
drippily1643033drippily
easily9313023_easily
emptily1445813emptily
fierily1339023fierily
filmily1535733filmily
firstly1335643firstly
fishily1637643fishily
fissile10269653fissile
flimsily1643283flimsily
fussily13267603fussily
gassily1137813gassily
giddily1335073giddily
gipsied1135873gipsied
gipsies1039903gipsies
gipsy11579543gips__y
gutsily11267223gutsily
happily1745763happily
hiply134113613hip__ly
horsily1338843horsily
icily101211693_i_cily
ickily1535753_ickily
itchily1574493itchily
kinkily1335223kinkily
lousily1038333lousily
messily12298813messily
milkily16216553milkily
mirkily16266403mirkily
missile92815403missile
missilry1344653missilry
mistily122612343mistily
mousily1239393mousily
mussily12279773mussily
niftily1335753niftily
noisily1038403noisily
nosily93712683_nosily
oilily93111723oi_lily
otiosely1143393otiosely
otiosity1155763otiosity
peppily1335133peppily
pily96132733__p_ily
piosity1268643piosity
pithily1567033pithily
prissily1346693prissily
prosily12611633prosily
pursily1238213pursily
ripely112511153rip_ely
ripply13348003rip_ply
risibly1235643ri_sibly
riskily1436413riskily
ritzily1945143ritzily
ropily113312443rop_ily
rosily93914713_rosily
sappily1437163sappily
sassily1038723sassily
silkily14236963silkily
sillily10209783sillily
slippily1544193slippily
snippily1543573snippily
spicily1438653spicily
spikily1635873spikily
stickily1736083stickily
stingily1236793stingily
tackily1637503tackily
tahsil936343tahsil_
tahsils1035053tahsils
tardily11269583tardily
tartily103511573tartily
tastily103311643tastily
tattily10409993tattily
tawnily1335443tawnily
tearily10311153tearily
techily1537123techily
tensely1037363tensely
tensibly1345143tensibly
tensile72612733tensile
tensity1039103tensity
tepidly1334413tepidly
tersely1038113tersely
testily102910803testily
thirstily1542693thirstily
thistly1395963thistly
thusly1235133thus_ly
tidally1137933tidally
tiddly11308783ti_ddly
tightly14327613tightly
timely113410113ti_mely
timidly1334593timidly
tingly103815973ti_ngly
tinkly134811153ti_nkly
tinsel639443tinsel_
tinselly1144613tinselly
tinsels738373tinsels
tipi69924433tip_i__
tipis76019923tip_i_s
tippier113210543tippier
tipping122814973tipping
tipple103411913tip_ple
tippy125411793tip__py
tips66436763tips___
tipsiest10228953tipsiest
tipster9299053tipster
tiredly1136803tiredly
tissuey1033663tissuey
tonsil6311873tonsil_
tonsils7310183tonsils
topsail976523topsail_
topsails1075093topsails
topside1037733topside
topsoil977143topsoil_
topsoils1095143topsoils
trashily1437323trashily
trickily1736233trickily
triply114211023trip__ly
trustily11257103trustily
tuftily1335573tuftily
typify1734523typ_ify
visibly1535043vi_sibly
waspily1535513waspily
wilily123310763wi_lily
windily1437943windily
wirily123310783wi_rily
wisely122711713wi_sely
wittily1336173wittily

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 Limit1340271426.84319586.0
3Display Results1421420.0463087.0
 (SQL Overall)1786911427.29524495.0
 
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.