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

147 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
smoothy1520508(None) 
smoochy17223861smoochy
smooth11259201smooth_
smoothly16203641smoothly
smooths12216321smooths
mothy136214552_m_othy
mouthy14409062_mouthy
smithy14508272sm_ithy
smooch13266802smooch_
smoosh11236732smoosh_
smoothed14236472smoothed
smoothen13204962smoothen
smoother13196672smoother
smoothes13218542smoothes
smoothie1344892smoothie
snooty94211512snoot_y
sooth85924062s_ooth_
soothe94214852s_oothe
soothly13186922s_oothly
sooths95715592s_ooths
sooty84924842s_oot_y
toothy12529692_toothy
besmooth1543353besmooth_
besmooths1642593besmooths
booth105522013_booth_
booths115313793_booths
booty106125913_boot_y
bothy136713963__bothy
brothy14519623_brothy
drouthy14395173drouthy
empathy1743483empathy
footsy12587933_footsy
footy115820533_foot_y
frothy15578373_frothy
growthy1773283growthy
hooty115022443_hoot_y
month104818423_month_
monthly1535673_monthly
months113812933_months
mooch125313613_mooch_
moody115017493_moo_dy
mooley11311633_mooley
moony104818273_moo_ny
moory105115793_moo_ry
moot67653623_moot__
mooted94120373_mooted
mooter83921093_mooter
moots75831663_moot_s
mostly113110943_mostly
motey105922953_m_otey
moth96731333_m_oth_
moths106021553_m_oths
mouth105420293_mouth_
mouths115214533_mouths
mythy16568673_m_ythy
resmooth1343633resmooth_
resmooths1442643resmooths
rooty86423023_root_y
scooch13228123scooch_
scoot75729153scoot__
scootch1434463scootch
scooted103612283scooted
scooter93312873scooter
scoots85315943scoot_s
scouth115011153scouth_
scouths12527893scouths
shoofly1634353shoofly
shoot84235913shoot__
shooter103013993shooter
shoots94619363shoot_s
shortly13387573shortly
shorty124313203short_y
sloshy12366623s_loshy
sloth85019453s_loth_
sloths94911893s_loths
slouchy15454843slouchy
sloughy14535803sloughy
smartly12497433smartly
smarty115013793smart_y
smith107818053sm_ith_
smiths114711023sm_iths
smoggy1354283sm_oggy
smokey15398653sm_okey
smokily1635373smokily
smoky14388683sm_o_ky
smolt74824163smolt__
smolts84411883smolt_s
smooched16185983smooched
smoocher15205503smoocher
smooches15217263smooches
smooshed14185993smooshed
smooshes13206863smooshes
smoothens14194253smoothens
smoothers14206043smoothers
smoothest14215773smoothest
smoothies1456133smoothies
smoothing1535293smoothing
smote75820283sm_ot_e
smother123510213sm_other
smothery16296063sm_othery
smutchy17193153smutchy
smutty11266323sm_utty
snoopy11449473snoo_py
snoot55030143snoot__
snooted84213283snooted
snootily1136253snootily
snoots64216683snoot_s
snoozy18517233snoo_zy
snotty9489203s_notty
snouty9419953snout_y
softly12457763s_oftly
softy115414483s_oft_y
sooey84522433s_oo_ey
soot45761063s_oot__
sooted73922593s_ooted
soothed113712743s_oothed
soother104215043s_oother
soothes103917113s_oothes
soothsay1442563s_oothsay
sootily101810523s_ootily
soots55536213s_oot_s
sophy136611763s__ophy
soth75932523s__oth_
soths86218633s__oths
south85223573s_outh_
souths95216603s_ouths
splotchy1841793splotchy
spoofy14498553spoo_fy
spooky15418093spoo_ky
spooney12418243spooney
spoony114111793spoo_ny
sporty115112493sport_y
spotty11448583s_potty
squooshy2381273squooshy
stithy12398213s_tithy
stoutly1035833stoutly
swarthy16466373swarthy
swoony12408263swoo_ny
swoopy14487283swoo_py
swoosh12195213swoosh_
sympathy2143613sympathy
timothy1543233timothy
tooth88020183_tooth_
tooths96013803_tooths
tootsy9437983_tootsy
worthy15598803_worthy
zooty175415353_zoot_y

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 Filter1786911340270.406440125.6
2DLD Change Limit1340271476.78019768.0
3Display Results1471470.0632333.3
 (SQL Overall)1786911477.24924650.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.