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

252 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
niftiest11291007(None) 
nifties102612501nifties_
nittiest82712601nittiest
wiftiest14279171wiftiest
bittiest103012042bittiest
dictiest113212782dictiest
dirtiest93014202dirtiest
driftiest1335942driftiest
fifties132111082fifties_
heftiest1439182heftiest
iffiest1337962_iffiest
lintiest82715912lintiest
loftiest1139082loftiest
miffiest1637132miffiest
miltiest103015172miltiest
mintiest103217142mintiest
mistiest103018312mistiest
mitiest93520052mi_tiest
nastiest83615952nastiest
nattiest83215352nattiest
nettiest83112432nettiest
niftier10328712niftie_r
niftiness1236362niftiness
nippiest12279972nippiest
nuttiest82312142nuttiest
shiftiest1537362shiftiest
siltiest83515612siltiest
sniffiest15236002sniffiest
tuftiest1138282tuftiest
wittiest112711522wittiest
airiest74221013ai_riest
artiest73121993_artiest
battiest104115553battiest
biffies152710853biffies_
bilgiest11309883bilgiest
bitsiest102610063bitsiest
buffiest1657563buffiest
bustiest102815053bustiest
cattiest103016333cattiest
cities84524853ci_ties_
cliffiest1743953cliffiest
craftiest1436913craftiest
daffiest1537843daffiest
daftest11248943daft_est
daintiest1039153daintiest
deftest112611713deft_est
diciest103316523di_ciest
dickiest153412503dickiest
dingiest102915373dingiest
dinkiest133812873dinkiest
dippiest132511133dippiest
dirties83119383dirties_
dishiest12313683dishiest
ditsiest92111323ditsiest
ditties83116983ditties_
ditziest18218473ditziest
dizziest17266723dizziest
dotiest83717453_dotiest
dottiest92611393dottiest
draftiest1335943draftiest
dustiest93015073dustiest
emptiest1278103emptiest
fattiest113514313fattiest
feistiest1237073feistiest
fieriest112112243fieriest
fiftieth1742583fiftieth
filmiest1338553filmiest
filthiest1545373filthiest
finniest113011403finniest
firriest112310433firriest
fishiest14310453fishiest
fittest102510803fi_ttest
fizziest19226073fizziest
fliest94718433__fliest
flintiest1248433flintiest
flirtiest1236193flirtiest
flutiest112610883flutiest
footiest113514913footiest
fustiest113014573fustiest
giddiest11298553giddiest
giftees11306513giftees_
giftless1245173giftless
gimpiest1338473gimpiest
ginniest92610513ginniest
girliest93010403girliest
glintiest1037623glintiest
gnattiest1035383gnattiest
goutiest93013883goutiest
grittiest10176983grittiest
guiltiest1035713guiltiest
gustiest92914523gustiest
guttiest92311223guttiest
hastiest112916493hastiest
hilliest113914113hilliest
hinkiest153311753hinkiest
hippiest152611613hippiest
hissiest112911093hissiest
hootiest113115643hootiest
huffiest1757203huffiest
iciest82914743_i_ciest
ickiest133611043_ickiest
infest93315433inf__est
inkiest113415043_inkiest
jettiest15359593jettiest
jiffies20327473jiffies_
jiggiest17277693jiggiest
jiviest1738113ji_viest
joltiest15249403joltiest
kickiest13319673kickiest
kilties113014143kilties_
kinkiest113110503kinkiest
kitties113213623kitties_
kittlest12297573kittlest
knottiest13174563knottiest
leftest10269463left_est
lefties10312073lefties_
leftist10279353lefti_st
limbiest12258893limbiest
limiest93716103li_miest
lingiest93715263lingiest
liniest73321153li_niest
lippiest122310613lippiest
lithest10513913li_thest
littlest8309243littlest
lustiest82914493lustiest
maltiest102916193maltiest
matiest92522453_matiest
meatiest102816793meatiest
mightiest1546443mightiest
milkiest142911083milkiest
minciest122913103minciest
mingiest113315823mingiest
miriest93619823mi_riest
mirkiest142910253mirkiest
mustiest103017533mustiest
naggiest102610013naggiest
nappiest122510883nappiest
nasties73520493nasties_
neatest72516003neat_est
neediest92611303neediest
nerdiest92511163nerdiest
nerviest11188833nerviest
nettliest945413nettliest
newsiest11107483newsiest
nicest82315663ni__cest
niceties10310863niceties_
niftily1335753nifti_ly
niggliest1144933niggliest
nighest11310693ni_ghest
nighties121011383nighties_
nimblest1236923nimblest
nineties8312913nineties_
ninnies73713613ninnies_
nites55736343ni_t_es_
nitres65519333ni_tres_
nittier73512243nittie_r
nixies135313873ni_xies_
nobbiest12117773nobbiest
noisiest839763noisiest
nosiest73415673n_osiest
nubbiest12117313nubbiest
nutsiest82710243nutsiest
oftest91212003_oft_est
oiliest72817683oi_liest
paintiest11310563paintiest
pastiest103319543pastiest
peatiest103118803peatiest
pestiest103018413pestiest
pettiest103113963pettiest
pickiest162712593pickiest
pieties9419223pieties_
pietist9414033pieti_st
piggiest12259663piggiest
piniest93121133pi_niest
pipiest113114493pi_piest
pithiest132711443pithiest
pities83828083pi_ties_
platiest103216083platiest
pointiest1139623pointiest
pottiest102815973pottiest
poutiest103016793poutiest
puffiest1647323puffiest
purtiest102414113purtiest
rattiest83516113rattiest
ribbiest1237583ribbiest
ridgiest1038903ridgiest
rifest93114583rif__est
riftless1136943riftless
rimiest93215853ri_miest
riskiest12310133riskiest
ritziest17237843ritziest
rootiest83115593rootiest
runtiest83014513runtiest
rustiest83116803rustiest
ruttiest82712663ruttiest
saltiest83117713saltiest
shirtiest1239323shirtiest
shittiest1238333shittiest
silkiest123212853silkiest
silliest84017103silliest
sissiest83412353sissiest
sixties14310973sixties_
siziest16311473si_ziest
slatiest82616263slatiest
slittiest938203slittiest
snippiest1345723snippiest
snootiest9178753snootiest
snottiest9167973snottiest
snoutiest9178253snoutiest
snuffiest15246053snuffiest
softest10310603soft_est
softies103414613softies_
sootiest84016753sootiest
spiffiest17235653spiffiest
swiftest1434353swift_est
tartiest82718313tartiest
tastiest83216633tastiest
tattiest83415383tattiest
tentiest82115613tentiest
testiest82715223testiest
thriftiest1643113thriftiest
tidiest83514873ti_diest
tiniest73020123ti_niest
tinniest82911463tinniest
tippiest122310013tippiest
tipsiest10228953tipsiest
titties73617363titties_
twistiest1235433twistiest
unifies102714713unif_ies_
unities72520153uni_ties_
vastiest112713073vastiest
viewiest1435853viewiest
viniest103216613vi_niest
wartiest113614643wartiest
whitiest14259883whitiest
wifeliest1545883wifeliest
wiftier13297733wiftie_r
wiggiest13269013wiggiest
wiliest103416593wi_liest
wimpiest1538763wimpiest
windiest122213233windiest
wingiest123214283wingiest
winiest103419693wi_niest
wintriest1238153wintriest
wiriest103816853wi_riest
wispiest1339513wispiest
withiest142411243withiest
wristiest1237753wristiest
zestiest173011103zestiest
zingiest182810893zingiest
zippiest21248093zippiest
zootiest173311213zootiest

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 Filter1786911461620.423422437.4
2DLD Change Limit1461622526.73321708.3
3Display Results2522520.0932709.7
 (SQL Overall)1786912527.24924650.4
 
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.