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

149 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
niftily133575(None) 
dirtily1138582dirtily
fifthly1943092fifthly
heftily1635762heftily
loftily1336352loftily
mistily122612342mistily
nastily103011032nastily
nattily103610322nattily
niftier10328712niftier
nifties102612502nifties
nifty115211632nift__y
ninthly1344212ninthly
nippily1444712nippily
nuttily10308632nuttily
shiftily1744542shiftily
sniffily17154032sniffily
tuftily1335572tuftily
wittily1336172wittily
airily93014823ai_rily
artily92814713_artily
bifidly1684233bifidly
cattily123210853cattily
citify1437443ci_tify
craftily1644783craftily
daffily1735133daffily
daftly1335443daft_ly
daintily1245523daintily
deftly1336533deft_ly
dingily1238103dingily
distil73616433distil_
distill83011323distill
distils83015803distils
dizzily1934843dizzily
dottily1147283dottily
draftily1534413draftily
dustily113211523dustily
emptily1445813emptily
fattily13379463fattily
feistily1445263feistily
fictile1238023fictile
fierily1339023fierily
fifties132111083fifties
fifty145211423fift__y
filmily1535733filmily
filthily1743663filthily
fishily1637643fishily
fitly115114973fi_t_ly
flintily1434893flintily
fustily133111373fustily
giddily1335073giddily
giftedly1642933giftedly
gifting123810893gifting
goutily1137933goutily
grittily1244183grittily
guiltily1243423guiltily
gustily113010903gustily
hastily133010663hastily
huffily1934693huffily
icily101211693_i_cily
ickily1535753_ickily
infill938413inf_ill
instil61111383instil_
instill789063instill
instils7811453instils
inutile739883inutile
joltily1746323joltily
kinkily1335223kinkily
knottily1543153knottily
licitly12276673licitly
lifting113313273lifting
lustily103611243lustily
meatily12311093meatily
mightily1744623mightily
milkily16216553milkily
mirkily16266403mirkily
mustily123613633mustily
nautili746113nautili
neatly93812483neat_ly
needily1166323needily
nervily1336863nervily
nettly9459453n_ettly
nicely1139493ni_cely
nidify1336763ni_dify
niftiest112910063niftiest
niggly11418913ni_ggly
nightly14449033nightly
nigrify1444133nigrify
nihil8410283ni_hil_
nihils937573ni_hils
nimbly13388773ni_mbly
nitery94412173ni_tery
nitid61817833ni_ti_d
nitrify1335793nitrify
nitril62511533nitril_
nitrile73011373nitrile
nitrils72810703nitrils
nittier73512243nittier
nitty85418313ni_t_ty
nobbily1436693nobbily
noily86120993n__oily
noisily1038403noisily
nonoily1049543nonoily
nosily93712683n_osily
notify1236943n_otify
oilily93111723oi_lily
pettily1238173pettily
pistil83915073pistil_
pistils93314303pistils
pithily1567033pithily
puffily1834843puffily
rifely123710033rif_ely
rifting113515003rifting
riskily1436413riskily
ritzily1945143ritzily
rustily103112993rustily
ruttily10338613ruttily
saltily10310543saltily
sifting113014593sifting
silkily14236963silkily
sillily10209783sillily
sixthly2042873sixthly
sniffly16265643snif_fly
snippily1543573snippily
snootily1136243snootily
snottily1145543snottily
snuffily17124313snuffily
softly12457763soft_ly
sootily101810513sootily
spiffily19153483spiffily
swiftly1633733swift_ly
tartily103511573tartily
tastily103311643tastily
tattily10409993tattily
testily102910803testily
thriftily1842003thriftily
tidily102811393ti_dily
tinily94014433ti_nily
tinnily1047363tinnily
tipsily1236043tipsily
unfitly1335573unfit_ly
wifely15429423wif_ely
wiftier13297733wiftier
wifty144212093wift__y
wilily123310763wi_lily
windily1437943windily
wintrily1445373wintrily
wirily123310783wi_rily
wispily1535653wispily
zestily19167563zestily

Search took 10 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.1561145455.1
2DLD Change Limit1340271499.42314223.4
3Display Results1491490.0463239.1
 (SQL Overall)1786911499.62518565.3
 
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.