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

353 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
campiest14221213(None) 
crampiest15268611crampiest
vampiest15237641vampiest
amplest11312332_amplest
bumpiest1437872bumpiest
cagiest102916432ca_giest
cakiest133215662ca_kiest
cambist13312112cambi_st
cammies134016482cammies_
campier133313272campie_r
campiness1537542campiness
canniest10313362canniest
cattiest103016332cattiest
clammiest1535732clammiest
clumpiest1535342clumpiest
comfiest1539132comfiest
crappiest15267262crappiest
crepiest12310382crepiest
crimpiest15237182crimpiest
cuppiest1448192cuppiest
dampest12411042damp_est
dumpiest1338742dumpiest
gamiest102816222gam_iest
gammiest13339322gammiest
gappiest13259472gappiest
gimpiest1338472gimpiest
hammiest152610002hammiest
happiest152411672happiest
hempiest1539022hempiest
humpiest1538962humpiest
jammiest19307202jammiest
jumpiest1936862jumpiest
lambiest122410182lambiest
lumpiest1239252lumpiest
nappiest122510882nappiest
pappiest112611112pappiest
rammiest12299932rammiest
raspiest10311272raspiest
sappiest122612572sappiest
scampies1439322scampies_
swampiest1635022swampiest
trampiest13227892trampiest
waspiest1338812waspiest
wimpiest1538762wimpiest
zappiest21228022zappiest
achiest12315183_achiest
aeriest73924053_aeriest
airiest74221013_airiest
ambient11310093_ambient
amidst94913233_am_idst
amies76837693_am_ies_
aptest82917513_a_ptest
artiest73121993_artiest
ashiest10313953_ashiest
babiest114414753ba_biest
baggiest123011753baggiest
balkiest144112453balkiest
balmiest124110993balmiest
barkiest144115153barkiest
barmiest125212783barmiest
barniest104815053barniest
battiest104115553battiest
bawdiest14398673bawdiest
beamiest123212763beam_iest
cabbies133115163cabbies_
caddies113718383caddies_
calmest11312343ca_lmest
camails11311753camails_
camases114216343camases_
cambism1538033cambi_sm
cambists1437023cambi_sts
cames97047313cam__es_
camisa103114323cam_i_sa
camise103319633cam_i_se
camises114218463cam_ises
camlet104426583cam_le_t
camlets114314623cam_lets
cammie124615293cammie__
camped134720233camp_e_d
camper124722213camp_e_r
campers134220293camp_ers
campfires1844123campfires_
camphene1746613camphene
camphines1847563camphines_
camphires1845783camphires_
campi116217783campi___
campily1638273campi_ly
camping143118973campi_ng
campings154010203campings
campion133011413campi_on
campions143511293campions
campos125217953camp_os_
campout13412853camp_out
campouts1436823campouts
camps116330263camp__s_
campsites1546473campsites_
campus125213923camp_us_
campused1535253campused
campuses1437773campuses
candidest1346533candidest
candies104125613candies_
canoeist10310693canoeist
canopies12311853canopies_
capes95441923ca_p_es_
capias10318353ca_pias_
capizes20410373ca_pizes_
capless114312763ca_pless
caplet104226813ca_ple_t
caplets114914523ca_plets
caries85147623ca_ries_
carnies94123963carnies_
carpet104530093carp_e_t
carpets113915333carp_ets
carries94328013carries_
casuist9411303casui_st
catchiest1638313catchiest
catties94023053catties_
cavies114525003ca_vies_
chaffiest2045413chaffiest
chalkiest1837083chalkiest
chammies172910163chammies_
chanciest1638373chanciest
chappies172610093chappies_
chariest13315503chariest
charriest1438253charriest
chattiest1448203chattiest
chewiest16177293chewiest
chippiest18256803chippiest
chirpiest16286473chirpiest
chokiest1738723chokiest
choppiest18226373choppiest
chummiest1834643chummiest
clankiest1536663clankiest
classiest11309543classiest
clayiest1337913clayiest
clumsiest1335393clumsiest
coaliest10316223coaliest
cobbiest14118523cobbiest
cockiest163013293cockiest
comeliest13410033comeliest
commies133718453commies_
compiles14311983compiles_
compleat14710153compleat
complect1659013complect
complies14314523complies_
compost134515353comp_ost
compress1439053compress
copies104130303c_opies_
corkiest143114793corkiest
corniest102117303corniest
cosiest93819853c_osiest
cowiest123614673c_owiest
cowpies143314283cowpies_
coziest184014353c_oziest
crabbiest1535623crabbiest
craftiest1436913craftiest
craggiest13116523craggiest
crampier14288903crampie_r
crampit1338863crampi__t
crampits1436273crampits_
crankiest1538823crankiest
crappies142911153crappies_
crawliest14187403crawliest
craziest19319923craziest
creamiest13248933cream_iest
creepiest1337063creepiest
crispiest13197423crispiest
croupiest1337063croupiest
crumbiest1536253crumbiest
crummiest1545563crummiest
crumpliest1644123crumpliest
curdiest112511393curdiest
curliest102713123curliest
curviest13309673curviest
cushiest133411043cushiest
daffiest1537843daffiest
damndest1276003damndest
dampish1567663dampi_sh
dampness1336073dampness
dandiest103415033dandiest
dashiest12311113dashiest
daubiest1138233daubiest
dimpliest1436583dimpliest
dippiest132511133dippiest
dopiest103315993_dopiest
earliest82415243earliest
easiest72318773ea_siest
elmiest9310743elm_iest
emptiest1278103_emptiest
faddiest1338113faddiest
faggiest132910183faggiest
fanciest133612713fanciest
fattiest113514313fattiest
fawniest14287443fawniest
flamiest133111973flam_iest
flappiest1644853flappiest
foamiest13289853foam_iest
frumpiest1634543frumpiest
fumiest12312193fum_iest
gabbiest1337273gabbiest
gamest94919923gam__est
gassiest93212523gassiest
gaudiest1039393gaudiest
gauziest1836233gauziest
gawkiest16327313gawkiest
gemmiest13227623gemmiest
glumpiest1434943glumpiest
goopiest112710553goopiest
grapiest112211923grapiest
gripiest11289633gripiest
grumpiest1435023grumpiest
gulpiest1137353gulpiest
gummiest13269023gummiest
hairiest11612463hairiest
handiest123417773handiest
hardiest123416333hardiest
harpies123818313harpies_
harpist12312353harpi_st
hastiest112916493hastiest
haziest193313003ha_ziest
hippiest152611613hippiest
homiest124116633hom_iest
hoppiest152610723hoppiest
imprest11310203_imprest
jaggiest17289323jaggiest
jammies183611293jammies_
jazziest2333813jazziest
jimpest18297553jimp_est
laciest93819033la_ciest
lakiest113517263la_kiest
lambies113015113lambies_
lamest84722763lam__est
lamppost1443513lamppost
lankiest122912493lankiest
lardiest93813883lardiest
larkiest123713313larkiest
lathiest11312653lathiest
laziest163814473la_ziest
limbiest12258893limbiest
limiest93716103lim_iest
limpest113712313limp_est
limpsiest1344793limpsiest
lippiest122310613lippiest
loamiest102310203loam_iest
loopiest103011313loopiest
loppiest122410103loppiest
magpies12310363magpies_
malmiest123211023malmiest
maltiest102916193maltiest
mamies104626243mam_ies_
mammies104314763mammies_
mangiest112815903mangiest
manliest102314943manliest
marliest102415183marliest
massiest103314423massiest
matiest92522453ma_tiest
maziest183613873ma_ziest
mopiest113014293_mopiest
naggiest102610013naggiest
nappies114613393nappies_
nastiest83615953nastiest
nattiest83215353nattiest
nippiest12279973nippiest
oakiest112913923oa_kiest
paciest112917803pa_ciest
paliest93021603pa_liest
palliest102814633palliest
palmiest123212023palmiest
papist102618743pa_pi_st
pappies103214823pappies_
pastiest103319543pastiest
pawkiest17277883pawkiest
peppiest11278563peppiest
pimpliest1545473pimpliest
pipiest113114493_pipiest
pulpiest1258433pulpiest
raciest92820013ra_ciest
rainiest81214923rainiest
ramies84630463ram_ies_
rampikes1635393rampikes_
randiest93418773randiest
rangiest93115983rangiest
rapidest1138543ra_pidest
rapist82520673ra_pi_st
rattiest83516113rattiest
rimiest93215853rim_iest
ropiest93317773_ropiest
roupiest102610293roupiest
rummiest12299353rummiest
rumpliest1345313rumpliest
saggiest102812713saggiest
sagiest82617983sa_giest
saltiest83117713saltiest
samples112815453samples_
sandiest93218683sandiest
sapient9415333sa_pient
sarkiest123615063sarkiest
sassiest83413613sassiest
sauciest10310973sauciest
savviest1435983savviest
scabbiest1534913scabbiest
scaliest101714393sca_liest
scampish1744893scampi_sh
scantiest112611003scantiest
scariest101615943sca_riest
scarriest11188393scarriest
scattiest11268363scattiest
scrappiest1644153scrappiest
scrimpiest1643743scrimpiest
scummiest1535213scummiest
seamiest102715413seam_iest
seepiest102412623seepiest
simplest122310223simplest
skimpiest1734503skimpiest
snappiest1346493snappiest
soapiest102412843soapiest
soppiest122511933soppiest
soupiest102212913soupiest
stumpiest1335853stumpiest
tackiest143112433tackiest
talkiest123611223talkiest
tamest85721293tam__est
tammies113814683tammies_
tangiest92915223tangiest
tardiest93515243tardiest
tarriest83215003tarriest
tartiest82718313tartiest
tastiest83216633tastiest
tattiest83415383tattiest
tawniest11279343tawniest
tawpies12309873tawpies_
tempest1139223temp_est
tippiest122310013tippiest
typiest1238203_typiest
vampier14308233vampie_r
vampires15226033vampires_
vampish1766283vampi_sh
vastiest112713073vastiest
wackiest172610273wackiest
wambliest16255153wambliest
wampish1777293wampi_sh
waniest103819113wa_niest
wariest105122503wa_riest
wartiest113614643wartiest
washiest14310403washiest
waviest134513073wa_viest
waxiest173510883wa_xiest
weepiest13219473weepiest
wispiest1339513wispiest
wombiest1536893wombiest
yummiest15256723yummiest
zaniest163214773za_niest
zippiest21248093zippiest

Search took 7 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.1561145455.1
2DLD Change Limit1461623536.65621959.4
3Display Results3533530.1402521.4
 (SQL Overall)1786913536.95225703.5
 
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.