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

362 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
surfiest11241442(None) 
scurfiest14236851scurfiest
surliest82416901surliest
turfiest112410121turfiest
buffiest1657552buffiest
burliest103113052burliest
burriest102911212burriest
curdiest112511392curdiest
curliest102713112curliest
curviest13309672curviest
furriest112910792furriest
furziest20267782furziest
gulfiest1247942gulfiest
huffiest1757192huffiest
murkiest143210262murkiest
puffiest1647312puffiest
pursiest102812122pursiest
purtiest102414112purtiest
sarkiest123615062sarkiest
scurviest14266112scurviest
snuffiest15246042snuffiest
sorriest8413882sorriest
spriest92718642spr_iest
stuffiest15235942stuffiest
sturdiest10207382sturdiest
suckiest143314102suckiest
sudsiest939612sudsiest
sulkiest124212492sulkiest
sunniest82712902sunniest
surest65026762sur__est
surfeit10310342surf_eit
surfeits1146222surfeits
surfier102613542surfie_r
aeriest73924053aer_iest
airiest74221013air_iest
artiest73121993_artiest
aurist65027253aur_i_st
barkiest144115153barkiest
barmiest125212783barmiest
barniest104815053barniest
beefiest13269013beefiest
blurriest1155153blurriest
buffest15298633bu_ffest
buggiest123410363buggiest
bulgiest112910943bulgiest
bulkiest143511263bulkiest
bulliest104314493bulliest
bumpiest1437873bumpiest
burbliest1365583burbliest
burdies104117563burdies_
buries84633273bur_ies_
burnies94017823burnies_
bushiest133512523bushiest
busiest93716303bu_siest
bustiest102815053bustiest
chuffiest2044393chuffiest
comfiest1539133comfiest
corkiest143114793corkiest
corniest102117303corniest
cuppiest1448193cuppiest
curies84934023cur_ies_
curries93723163curries_
curtest9713963cur_test
cushiest133411043cushiest
daffiest1537833daffiest
dirtiest93014203dirtiest
dorkiest133111253dorkiest
driest74722753_dr_iest
duckiest153211863duckiest
dumpiest1338743dumpiest
dungiest102810743dungiest
durndest1065763durndest
durries83817353durries_
duskiest133710083duskiest
dustiest93015073dustiest
earliest82415243earliest
eeriest73620673eer_iest
esurient849293esur_ient
ferniest1132214153ferniest
firriest112310433firriest
fluffiest1434083fluffiest
forkiest153812303forkiest
fubsiest13258413fubsiest
fuggiest13228813fuggiest
fumiest12312193fu_miest
funfest13348083funf_est
funkiest152810973funkiest
funniest113010733funniest
furies95126373fur_ies_
furthest1496863furthest
fussiest112910493fussiest
fustiest113014573fustiest
fuzziest19235793fuzziest
germiest11249913germiest
girliest93010403girliest
goofiest12289393goofiest
goriest82218743gor_iest
gorsiest92511133gorsiest
gruffest1544583gruffest
gruffiest1634523gruffiest
gulpiest1137353gulpiest
gummiest13269023gummiest
gunkiest132610573gunkiest
gurries83515953gurries_
gushiest123510983gushiest
gustiest92914523gustiest
gutsiest92610583gutsiest
guttiest92311223guttiest
hardiest123416333hardiest
herbiest1339993herbiest
horniest112814043horniest
horsiest112513263horsiest
hulkiest15329713hulkiest
humpiest1538963humpiest
hunkiest153812333hunkiest
hurdies114015663hurdies_
hurlies103315333hurlies_
hurries103919653hurries_
huskiest153210413huskiest
iffiest1337953_iffiest
jerkiest19328113jerkiest
juiciest1736923juiciest
jumpiest1936863jumpiest
junkiest192610173junkiest
juries134120633jur_ies_
jurist134616393jur_i_st
knurliest1344063knurliest
lardiest93813883lardiest
larkiest123713313larkiest
leafiest113410883leafiest
luckiest143011443luckiest
lumpiest1239253lumpiest
luniest73516993lu_niest
lustiest82914493lustiest
marliest102415183marliest
merriest10311473merriest
miffiest1637123miffiest
miriest93619823mir_iest
mirkiest142910253mirkiest
muckiest163210913muckiest
muddiest12298733muddiest
muggiest12228533muggiest
murkest133110203mur_kest
murries94118673murries_
mushiest133212873mushiest
muskiest143311553muskiest
mussiest103112933mussiest
mustiest103017533mustiest
muzziest18175833muzziest
nerdiest92511163nerdiest
nerviest11188833nerviest
nubbiest12117303nubbiest
nutsiest82710233nutsiest
nuttiest82312133nuttiest
orbiest9312413_orbiest
perkiest143313243perkiest
porkiest143513713porkiest
porniest103214313porniest
priest84125423_pr_iest
pudgiest12297893pudgiest
puggiest12219223puggiest
pulpiest1258433pulpiest
puniest92918093pu_niest
punkiest149312663punkiest
punniest102511583punniest
purest84021933pur__est
purfles122511843purfles_
purifies13311923purifies_
purist85525053pur_i_st
purplest12249123purplest
pushiest133211713pushiest
pussiest102911753pussiest
quakiest2138583quakiest
quirkiest2234373quirkiest
reefiest112811483reefiest
rifest93114583__rifest
rubiest92914423ru_biest
ruddiest10278543ruddiest
ruffliest1554483ruffliest
ruliest72816423ru_liest
rummiest12299353rummiest
runniest82911203runniest
runtiest83014513runtiest
rushiest113312923rushiest
rustiest83116803rustiest
ruttiest82712663ruttiest
safest95016603s_af_est
saggiest102812713saggiest
sagiest82617983s_agiest
saltiest83117713saltiest
sandiest93218683sandiest
sappiest122612573sappiest
sassiest83413613sassiest
sauciest10310963sauciest
sauries72821623saur_ies_
savviest1435983savviest
scaliest101714383scaliest
scariest101615943scariest
scarriest11188393scarriest
screwiest1445463screwiest
scries85226823scr_ies_
scruffiest1842923scruffiest
scummiest1535203scummiest
scurfier13267053scurfie_r
scurries102911483scurries_
scurvies13248123scurvies_
scuzziest1942993scuzziest
seamiest102715413seamiest
sedgiest10259763sedgiest
seediest92714053seediest
seepiest102412623seepiest
serenest82717623serenest
serest64831613ser__est
serfish1348973serfi_sh
series64540973ser_ies_
serries73925353serries_
sexiest142112223s_exiest
shadiest121711273shadiest
shakiest151910933shakiest
shaliest111415043shaliest
shiest95821523s__hiest
shiftiest1537353shiftiest
shiniest113212493shiniest
shirtiest1239323shirtiest
showiest1438783showiest
silkiest123212853silkiest
silliest84017093silliest
siltiest83515613siltiest
sirupiest1154753sirupiest
sissiest83412353sissiest
siziest16311473s_iziest
skunkiest12135083skunkiest
slatiest82616263slatiest
sliest66621943s__liest
slimiest10310743slimiest
sludgiest1135793sludgiest
slugfest1244913slugf_est
slummiest1335653slummiest
slurries82710413slurries_
slushiest1267023slushiest
sluttiest937323sluttiest
smarmiest1335903smarmiest
smirkiest1535193smirkiest
smokiest1437883smokiest
smudgiest1334363smudgiest
smuttiest1135963smuttiest
snakiest122110533snakiest
snarkiest13207623snarkiest
snarliest91810193snarliest
sniffiest15235993sniffiest
snowiest1138133snowiest
snubbiest1345063snubbiest
snuffliest1633493snuffliest
soapiest102412843soapiest
softest10310603s_oftest
soggiest102711643soggiest
sonsiest8313033sonsiest
sootiest84016753sootiest
soppiest122511933soppiest
sorest65027993sor__est
sorties74126403sorties_
soupiest102212903soupiest
sourest7515713sour__est
spaciest122310893spaciest
sparkiest15188093sparkiest
sparriest11198783sparriest
spiciest122711603spiciest
spiffiest17235643spiffiest
spikiest14259533spikiest
spiniest102813223spiniest
spiriest102513453spiriest
splurgiest1343213splurgiest
sportiest111711023sportiest
sprucest12295783sprucest
spruciest1345143spruciest
spryest12247813spr_yest
spumiest1238193spumiest
spunkiest15166553spunkiest
spurries102311323spurries_
squiffiest2542653squiffiest
squirmiest2142773squirmiest
stagiest91613403stagiest
starriest9159763starriest
stiffest1435673stiffest
stoniest8413543stoniest
stormiest1137003stormiest
straitest949173straitest
strawiest1237213strawiest
strifes104716583strifes_
stripiest1138013stripiest
stubbiest1345473stubbiest
studliest1036563studliest
stumpiest1335843stumpiest
sturdies92110273sturdies_
suavest10310623su_avest
subfield1444753subfield
subfiles131710713subfiles_
subfixes20207493subfixes_
sublimest1346703sublimest
subsist9311573subsi_st
subtest9513963su_btest
subtilest1148803subtilest
subtlest10511353subtlest
suffices16208173suffices_
suffixes21196343suffixes_
sugariest1038123sugariest
suggest9310863su_ggest
sulfides1238053sulfides_
sulfids1137293sulfids_
sulfites1139903sulfites_
sulkies114315763sulkies_
sullies74122223sullies_
sultriest938643sultriest
sumoist9311613sumoi_st
sunfast1038503sunf_ast
sunfish1338883sunfi_sh
supplest1248933supplest
supremest1347033supremest
sureness8912903sureness
sureties8316583sureties_
surfaces1338673surfaces_
surfboat1345333surfboat
surfed103814463surf_e_d
surfer93515883surf_e_r
surfers103614133surf_ers
surffish1744783surffish
surfing112914483surfi_ng
surfings12268073surfings
surfmen1235993surfme_n
surfs85022543surf__s_
surges73924593sur_ges_
surlier72915443surlie_r
surliness939943surliness
surmise9311083surmi_se
surmised1136853surmised
surmiser1036763surmiser
surmises10310643surmises
survives1436333survives_
swiftest1434353swiftest
swirliest1236283swirliest
syrupiest1453223syrupiest
tardiest93515243tardiest
tarriest83215003tarriest
tartiest82718313tartiest
tubbiest12117293tubbiest
tuftiest1138273tuftiest
turfier10249793turfie_r
turfless1135533turfless
ugliest8410143_ugliest
usuries7510633usur_ies_
veriest103719133ver_iest
vuggiest13216923vuggiest
wariest105122503war_iest
wartiest113614643wartiest
wiriest103816853wir_iest
wordiest122311543wordiest
wormiest13249543wormiest
wriest94419713_wr_iest
wussiest11268663wussiest
yuckiest17328833yuckiest
yukkiest14214533yukkiest
yummiest15256723yummiest

Search took 9 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 Limit1461623628.48317230.0
3Display Results3623620.1562320.5
 (SQL Overall)1786913628.81220278.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.