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

158 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
nippily144471(None) 
snippily1543571snippily
drippily1643032drippily
happily1745762happily
niftily1335752niftily
nippier11319832nippier
nipping123412872nipping
nippingly1743982nippingly
nipple103410372nipp_le
nippy124911112nipp__y
peppily1335122peppily
ripply13348002ripp_ly
sappily1437162sappily
slippily1544192slippily
snappily1544322snappily
tipsily1236042tipsily
wispily1535652wispily
airily93014823ai_rily
apply125111393_app_ly
bumpily1665653bumpily
campily1638273campily
chirpily1843773chirpily
choppily2044133choppily
crispily1574693crispily
dimply14339743dimp_ly
dingily1238103dingily
dippier123111393dippier
dipping134014833dipping
dippy135111543dipp__y
dirtily1138583dirtily
dizzily1934843dizzily
dopily123510463_dopily
dumpily1566233dumpily
emptily1445813emptily
fierily1339023fierily
filmily1535733filmily
fipple13329063fipp_le
fishily1637643fishily
floppily1843773floppily
giddily1335073giddily
gipping133813123gipping
hiply134113613hi_p_ly
hippie132811243hippi_e
hippier143212103hippier
hippies142813743hippies
hipping153915103hipping
hippish1736183hippish
hippy155112793hipp__y
icily101211693_i_cily
ickily1535753_ickily
imply124911843_imp_ly
inaptly1244413inaptly
ineptly1245073ineptly
jimply20397483jimp_ly
jumpily2174983jumpily
kinkily1335223kinkily
kipping163311873kipping
limpidly1643153limpidly
limply133810033limp_ly
lippier112710573lippier
lipping123016073lipping
lippy124511903lipp__y
loopily1236803loopily
lumpily1476563lumpily
milkily16216553milkily
mirkily16266403mirkily
mistily122612343mistily
nappie104112263nappi_e
nappier114411173nappier
nappies114613393nappies
napping123514183napping
nappy126312333napp__y
nastily103011033nastily
nattily103610323nattily
needily1166323needily
nervily1336863nervily
nicely1139493ni_cely
nidify1336763ni_dify
niggly11418913ni_ggly
nightly14449033nightly
nigrify1444133nigrify
nihil8410283ni_hil_
nihils937573ni_hils
nimbly13388773ni_mbly
ninthly1344213ninthly
nipped113615853nipp_ed
nipper103715713nipp_er
nippers113012623nippers
nippiest12279973nippiest
nippled12307643nippled
nipples11319663nipples
nitpick1543783nitpick
nitpicky1951693nitpicky
nitrify1335793nitrify
nitril62511533nitril_
nitrile73011373nitrile
nitrils72810703nitrils
nobbily1436693nobbily
noily86120993n__oily
noisily1038403noisily
nonoily1049543nonoily
nosily93712683n_osily
nuttily10308633nuttily
oilily93111723oi_lily
pily96132733___pily
pimply15329213pimp_ly
pippin92810303pippi_n
pipping113414743pipping
pippins10319753pippins
pithily1567033pithily
preppily1444583preppily
pulpily1436103pulpily
ripely112511153ri_pely
ripping123315743ripping
rippingly1744233rippingly
ripple103413913ripp_le
riskily1436413riskily
ritzily1945143ritzily
ropily113312443_ropily
roupily1246653roupily
silkily14236963silkily
sillily10209783sillily
simply133010523simp_ly
sipping123117433sipping
skimpily1963053skimpily
sloppily1544613sloppily
sniffily17154033sniffily
snippety15263493snippety
snippier1255793snippier
snipping13308853snipping
snippy1374843snipp__y
snoopily1345553snoopily
soapily1237963soapily
spicily1438653spicily
spikily1635873spikily
supply1346893supp_ly
tidily102811393ti_dily
tinily94014433ti_nily
tinnily1047363tinnily
tippier113210543tippier
tipping122814973tipping
tipple103411913tipp_le
tippy125411793tipp__y
unhappily1982083unhappily
uppile10178503_uppile
uppity1335103_uppity
waspily1535513waspily
wilily123310763wi_lily
windily1437943windily
wirily123310783wi_rily
wittily1336173wittily
yippie13277843yippi_e
yippies14279293yippies
yipping152710683yipping
yuppify2042163yuppify
zippier20308193zippier
zipping212910573zipping
zippy21518743zipp__y

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 Limit1340271587.09318895.7
3Display Results1581580.0632507.9
 (SQL Overall)1786911587.29924481.6
 
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.