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

354 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
sappiest12261257(None) 
gappiest13259471gappiest
happiest152411671happiest
nappiest122510881nappiest
pappiest112611111pappiest
snappiest1346481snappiest
soppiest122511931soppiest
zappiest21228021zappiest
campiest142212132campiest
crappiest15267262crappiest
cuppiest1448192cuppiest
dippiest132511132dippiest
flappiest1644852flappiest
hippiest152611612hippiest
hoppiest152610722hoppiest
lippiest122310612lippiest
loppiest122410102loppiest
nappies114613392nappies_
nippiest12279972nippiest
pappies103214822pappies_
peppiest11278562peppiest
raspiest10311272raspiest
saggiest102812712saggiest
sagiest82617982sa_giest
saltiest83117712saltiest
sandiest93218682sandiest
sapient9415332sa_pient
sapphist1545762sapphist
sappier113613112sappie_r
sappiness1337432sappiness
sarkiest123615062sarkiest
sassiest83413612sassiest
sauciest10310962sauciest
savviest1435982savviest
scrappiest1644152scrappiest
seepiest102412622seepiest
slippiest1346462slippiest
sloppiest1345972sloppiest
snippiest1345712snippiest
soapiest102412842soapiest
soupiest102212902soupiest
spaciest122310892spaciest
spriest92718642s_priest
strappiest1444362strappiest
supplest1248932supplest
swampiest1635022swampiest
tippiest122310012tippiest
vampiest15237642vampiest
waspiest1338812waspiest
zippiest21248092zippiest
achiest12315183_achiest
aeriest73924053_aeriest
airiest74221013_airiest
amplest11312333_amplest
apples104315763_apples_
applet105917433_apple_t
applets115710063_applets
applies11311213_applies_
aptest82917513_a_ptest
artiest73121993_artiest
ashiest10313953_ashiest
babiest114414753ba_biest
baggiest123011753baggiest
balkiest144112453balkiest
balmiest124110993balmiest
baptist11311873bapti_st
barkiest144115153barkiest
barmiest125212783barmiest
barniest104815053barniest
battiest104115553battiest
bawdiest14398673bawdiest
bumpiest1437873bumpiest
buppies133011063buppies_
cagiest102916433ca_giest
cakiest133215663ca_kiest
canniest10313363canniest
cattiest103016333cattiest
chappies172610093chappies_
chippiest18256803chippiest
choppiest18226373choppiest
crampiest15268613crampiest
crappies142911153crappies_
crepiest12310383crepiest
daffiest1537833daffiest
dampest12411043damp_est
dandiest103415033dandiest
dapperest1445283dapperest
dapples1238993dapples_
dashiest12311113dashiest
daubiest1138233daubiest
dopiest103315993_dopiest
drippiest1445363drippiest
dumpiest1338743dumpiest
earliest82415243earliest
easiest72318773ea_siest
emptiest1278103emptiest
faddiest1338113faddiest
faggiest132910183faggiest
fanciest133612713fanciest
fattiest113514313fattiest
fawniest14287443fawniest
floppiest1654773floppiest
gabbiest1337273gabbiest
gamiest102816223ga_miest
gammiest13339323gammiest
gappier12369843gappie_r
gassiest93212523gassiest
gaudiest1039393gaudiest
gauziest1836233gauziest
gawkiest16327313gawkiest
gimpiest1338473gimpiest
gloppiest1444823gloppiest
goopiest112710553goopiest
grapiest112211923grapiest
gripiest11289633gripiest
grippiest1435143grippiest
gulpiest1137353gulpiest
guppies123310523guppies_
hairiest11612463hairiest
hammiest152610003hammiest
handiest123417773handiest
happier143312033happie_r
happiness1635993happiness
hardiest123416333hardiest
harpies123818313harpies_
harpist12312353harpi_st
hastiest112916493hastiest
haziest193313003ha_ziest
hempiest1539023hempiest
heppest14228143hepp_est
hippest14219753hipp_est
hippies142813743hippies_
humpiest1538963humpiest
jaggiest17289323jaggiest
jammiest19307203jammiest
jazziest2333813jazziest
jumpiest1936863jumpiest
koppies153210013koppies_
laciest93819033la_ciest
lakiest113517263la_kiest
lambiest122410183lambiest
lankiest122912493lankiest
lappet103817723lapp_e_t
lappets11329123lapp_ets
lardiest93813883lardiest
larkiest123713313larkiest
lathiest11312653lathiest
laziest163814473la_ziest
loopiest103011313loopiest
lumpiest1239253lumpiest
magpies12310363magpies_
malmiest123211023malmiest
maltiest102916193maltiest
mangiest112815903mangiest
manliest102314943manliest
marliest102415183marliest
massiest103314423massiest
matiest92522453ma_tiest
maziest183613873ma_ziest
mopiest113014293_mopiest
naggiest102610013naggiest
nappes104515623napp_es_
nappie104112263nappie__
nappier114411173nappie_r
nappiness1335233nappiness
nastiest83615953nastiest
nattiest83215353nattiest
oakiest112913923oa_kiest
paciest112917803pa_ciest
paliest93021603pa_liest
palliest102814633palliest
palmiest123212023palmiest
papist102618743pa_pi_st
pappier103511593pappie_r
pastiest103319543pastiest
pawkiest17277883pawkiest
pipiest113114493_pipiest
poppies102816193poppies_
preppiest1236973preppiest
priest84125423__priest
pulpiest1258433pulpiest
puppies103212613puppies_
quippiest2243983quippiest
raciest92820013ra_ciest
rainiest81214923rainiest
rammiest12299933rammiest
randiest93418773randiest
rangiest93115983rangiest
rapidest1138543rapidest
rapist82520673ra_pi_st
rappees113611453rappees_
rattiest83516113rattiest
rippliest1334763rippliest
ropiest93317773_ropiest
roupiest102610293roupiest
sacrist9315423sacri_st
saddest92412383sa_ddest
sadist74221353sa_di_st
safest95016603sa__fest
sagest74920263sa__gest
salient7419763sa_lient
sallies73227813sallies_
salpids1038193salpids_
saltest71916513sa_ltest
salties73725773salties_
samples112815453samples_
sanest64426693sa__nest
sanies63031953sa_nies_
sapiens9310173sa_piens
sapients1037423sa_pients
sapless93313443sa_pless
sapotes9313933sapotes_
sapped114422013sapp_e_d
sapper103822353sapp_e_r
sappers113518893sapp_ers
sapphics1743413sapphics_
sapphires1644033sapphires_
sapphism1743803sapphism
sapphists1644103sapphists
sappily1437163sappi_ly
sapping123519313sappi_ng
sassies74719263sassies_
sauries72821623sauries_
savagest1245763savagest
savoriest1246613savoriest
savvies1337603savvies_
sayest94217743sa__yest
scabbiest1534913scabbiest
scaliest101714383scaliest
scampies1439323scampies_
scantiest112611003scantiest
scariest101615943scariest
scarriest11188393scarriest
scattiest11268363scattiest
seamiest102715413seamiest
sedgiest10259763sedgiest
seediest92714053seediest
sexiest142112223s_exiest
shabbiest1635323shabbiest
shadiest121711273shadiest
shaggiest14156893shaggiest
shakiest151910933shakiest
shaliest111415043shaliest
shapeliest1544953shapeliest
sharpest1339143sharp_est
sharpies13411223sharpies_
shiest95821523s__hiest
shiniest113212493shiniest
showiest1438783showiest
silkiest123212853silkiest
silliest84017093silliest
siltiest83515613siltiest
simplest122310223simplest
sippet103519393sipp_e_t
sippets113310173sipp_ets
sirupiest1154753sirupiest
sissiest83412353sissiest
siziest16311473s_iziest
skankiest12145703skankiest
skimpiest1734503skimpiest
slaggiest11157703slaggiest
slangiest10129073slangiest
slatiest82616263slatiest
sleepiest1136713sleepiest
sliest66621943s__liest
slimiest10310743slimiest
smarmiest1335903smarmiest
smokiest1437883smokiest
snaggiest11126663snaggiest
snakiest122110533snakiest
snappier1266213snappie_r
snappiness1443823snappiness
snappish1545233snappi_sh
snarkiest13207623snarkiest
snarliest91810193snarliest
snazziest1743123snazziest
snoopiest11157053snoopiest
snowiest1138133snowiest
soggiest102711643soggiest
sonsiest8313033sonsiest
sootiest84016753sootiest
sophies12314613sophies_
sophist12311563sophi_st
soppier112711583soppie_r
soppiness1336543soppiness
sorriest8413883sorriest
sparest94616423s_parest
sparkiest15188093sparkiest
sparriest11198783sparriest
sparsest1048813sparsest
spavies123012943spavies_
spaviet123011923spavie_t
spiciest122711603spiciest
spies76037623s__pies_
spikiest14259533spikiest
spiniest102813223spiniest
spiriest102513453spiriest
spryest12247813s_pryest
spumiest1238193spumiest
staggiest11148253staggiest
stagiest91613403stagiest
stalkiest1347903stalkiest
starriest9159763starriest
stoniest8413543stoniest
stripiest1138013stripiest
stroppiest1444553stroppiest
stumpiest1335843stumpiest
stupidest1244143stupidest
suckiest143314103suckiest
sudsiest939613sudsiest
sulkiest124212493sulkiest
sunniest82712903sunniest
supples11511283supples_
supplies1268823supplies_
suppress1236443suppress
surfiest112414423surfiest
surliest82416903surliest
swankiest16136203swankiest
sweepiest1435673sweepiest
swoopiest14155383swoopiest
syrupiest1453223syrupiest
tackiest143112433tackiest
talkiest123611223talkiest
tangiest92915223tangiest
tappet103820113tapp_e_t
tappets113610013tapp_ets
tardiest93515243tardiest
tarriest83215003tarriest
tartiest82718313tartiest
tastiest83216633tastiest
tattiest83415383tattiest
tawniest11279343tawniest
tawpies12309873tawpies_
tipsiest10228953tipsiest
trampiest13227893trampiest
trippiest1336583trippiest
typiest1238203_typiest
unhappiest1742413unhappiest
vastiest112713073vastiest
wackiest172610273wackiest
waniest103819113wa_niest
wariest105122503wa_riest
wartiest113614643wartiest
washiest14310403washiest
waviest134513073wa_viest
waxiest173510883wa_xiest
weepiest13219473weepiest
whippiest19265113whippiest
wimpiest1538763wimpiest
wispiest1339513wispiest
yippies14279293yippies_
yuppies14339263yuppies_
zaniest163214773za_niest
zappier20458373zappie_r

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 Filter1786911461620.1731032896.0
2DLD Change Limit1461623548.86016496.8
3Display Results3543540.1402528.6
 (SQL Overall)1786913549.17319480.1
 
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.