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

172 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
smoother1319667(None) 
smoocher15205501smoocher
smoothed14236471smoothed
smoothen13204961smoothen
smoothers14206041smoothers
smoothes13218541smoothes
smother123510211sm_other
soother104215041s_oother
moocher143610672_moocher
mooter83921092_moot_er
mother113718642_m_other
mouther123812812_mouther
scooter93312872scoot_er
scouther1356942scouther
shooter103013992shoot_er
smooched16185982smooched
smoochers16184832smoochers
smooches15217262smooches
smooshed14185992smooshed
smooshes13206862smooshes
smooth11259202smooth__
smoothens14194252smoothens
smoothest14215772smoothest
smoothie1344892smoothie
smoothies1456132smoothies
smoothly16203642smoothly
smooths12216322smooth_s
smoothy15205082smooth_y
smothers13349932sm_others
smothery16296062sm_othery
snootier8278382snootier
soothe94214852s_oothe_
soothed113712742s_oothed
soothers113913432s_oothers
soothes103917112s_oothes
sootier73916612s_ootier
souther104116302s_outher
another10289153_another
besmoothed1842403besmoothed
bother115218063__bother
brother123311333_brother
comether1537253comether
cooter85128613_coot_er
couther123914633_couther
emoter85415193em_ot_er
footer94320773_foot_er
footier104115113_footier
footler104011873_footler
frother133110153_frother
hooter94123933_hoot_er
hootier104915353_hootier
loather103711003_loather
looter64222323_loot_er
mither114218563_m_ither
molter84119423_molt_er
mooched153910533_mooched
moochers15369123_moochers
mooches143714453_mooches
moodier103212203_moodier
mooner85317833_moo_ner
moonier93714103_moonier
moorhen1236023_moorhen
moorier93113073_moorier
mooted94120373_moot_ed
mooters93818623_moot_ers
mosher114719793_m_osher
mothers123717623_m_others
mothery153710513_m_othery
mothier121910213_m_othier
mottler94410343_mottler
mouthed133811043_mouthed
mouthers133811303_mouthers
mouthier13208173_mouthier
murther1237953_murther
norther1039733_norther
nother93815963__nother
other84219103___other
pother113818853__pother
resmoothed1642563resmoothed
rooter64926033_root_er
rootier74915393_rootier
scooched16206683scooched
scooches15188413scooches
scooper113812033scoo_per
scootched1763963scootched
scootches1635003scootches
scooted103612283scoot_ed
scooters103511033scoot_ers
scorcher15196793scorcher
scoter83815483s_cot_er
scouter93313323scout_er
scouthers1445993scouthers
sheather1458233sheather
shooters112811583shoot_ers
shorter103515503short_er
shouter103213083shout_er
slather103816083s_lather
slither104112983s_lither
slotter73314453s_lotter
sloucher13206813sloucher
smarter94113133smart_er
smasher123911023sm_asher
smatter93613333sm_atter
smelter93311913smelt_er
smiter83616413sm_it_er
smithers13369793sm_ithers
smithery16325703sm_ithery
smoggier1243973smoggier
smoker124311693sm_o_ker
smokier1356703sm_okier
smolder10327753sm_older
smooch13266803smooch__
smoochy17223863smooch_y
smoosh11236733smoosh__
smoothbore1751283smoothbore
smoothened1642483smoothened
smoothing1535293smoothing
smoothness1543043smoothness
smote75820283sm_ot_e_
smothered1545683sm_othered
smotherer1444633sm_otherer
smoulder1133443smoulder
smuttier1035213smuttier
snooker113910303snoo_ker
snooper93511533snoo_per
snoopier10177273snoopier
snooted84213283snoot_ed
snoozer16409193snoo_zer
snoozier17185193snoozier
snorter74412663snort_er
snottier8217383snottier
snoutier8206973snoutier
softer94015313s_oft_er
sooner64220463s_oo_ner
sooted73922593s_oot_ed
sooth85924063s_ooth__
soothest113312243s_oothest
soothly13186923s_oothly
sooths95715593s_ooth_s
sorter64425093s_ort_er
souter64225923s_out_er
southed114313993s_outhed
southern11438913s_outhern
southers114214453s_outhers
spoofer12368723spoo_fer
spookier14175493spookier
spooler93711383spoo_ler
spoonier10167653spoonier
sporter93616553sport_er
sportier102010053sportier
spotter94514883s_potter
spottier10207313spottier
spouter94213223spout_er
stooker113811733stoo_ker
stooper93813193stoo_per
stouter74012053stout_er
swather134213603s_wather
swither133710993s_wither
swooner10358673swoo_ner
swoonier11185133swoonier
swooper12389173swoo_per
swoopier13175143swoopier
swooshed15174273swooshed
swooshes14185123swooshes
swotter10399473s_wotter
tooter64420803_toot_er
toothed113310243_toothed
toothier1136423_toothier
tootler73511123_tootler
tother94117143__tother
unsmoothed1642003unsmoothed
zootier163611173_zootier

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.406440125.6
2DLD Change Limit1461621727.17320376.7
3Display Results1721720.0762263.2
 (SQL Overall)1786911727.65523343.0
 
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.