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

117 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
seasoning103741(None) 
reasoning10310201reasoning
seasonings1143291seasonings
beaconing1436632beaconing
deaconing1337192deaconing
lessoning1044772lessoning
masoning1139762_masoning
reasonings1143652reasonings
reseasoning1243002reseasoning
seagoing1038192seago_ing
weaponing1545382weaponing
atoning83514873__atoning
beaning103820683bea__ning
beckoning1845773beckoning
blazoning2144033blazoning
ceasing104118263ceas__ing
censoring1238783censoring
crayoning1535243crayoning
deadening1277583deadening
deafening1476273deafening
deaning94020473dea__ning
deashing134210953deas_hing
deboning12109153de_boning
deponing121211213de_poning
earning83418213_ea_rning
easing74926463_eas__ing
easting84924303_eas_ting
feasing113916653feas__ing
feasting122011323feas_ting
leadening1176733leadening
leaning83721203lea__ning
learning978553lea_rning
leashing123310313leas_hing
leasing83920163leas__ing
leavening1365973leavening
lesioning1046443lesioning
lessening1045333lessening
meaning103918703mea__ning
measuring1236123measuring
neatening1038353neatening
pensioning1345913pensioning
poisoning1245903poisoning
prisoning1237643prisoning
readorning1245723readorning
reavowing1634863reavowing
reckoning1637643reckoning
resining92919553re_sining
resoling92916303re_soling
resowing123111523re_sowing
rezoning18310453re_zoning
saining83621393s_a_ining
saning75127643s_a__ning
saponin9310263s_aponin_
saponine1039223s_aponine
saponins1039453s_aponins
sashing114621473s_as_hing
sassing84615553s_as_sing
savoring1269483s_avoring
scanning113310773sca_nning
seafaring1345963seafaring
sealing83528563sea__ling
seaming103222113sea__ming
searching1538343searching
searing83330923sea__ring
searobin1045713searobin_
searobins1145553searobins
season62714903seaso__n_
seasonal847263season_al
seasonals945283seasonals
seasoned948113season_ed
seasoner857693season_er
seasoners946263seasoners
seasons72614233seaso__ns
seating84130683sea__ting
secerning1246203secerning
seconding1337613se_conding
sectioning1346293sectioning
sectoring1239583sectoring
seesawing1343653seesawing
seining84020773se__ining
seising84018863seis__ing
sensating1039253sensating
sensing84116953sens__ing
sequining1945323sequining
shadowing1744263shadowing
shamoying1844523shamoying
siphoning1546133siphoning
slaloming1244743slaloming
slashing123713413slas_hing
smashing143310243smas_hing
spanning113311083spa_nning
spasming13227203spas_ming
spawning14296913spa_wning
speaning113512243spea__ning
spooning112811443s_pooning
staining9413373sta_ining
staning83922243sta__ning
stashing123511583stas_hing
stationing1145283stationing
stoning83717443s__toning
summoning14115693summoning
swanning12338813swa_nning
swashing15369743swas_hing
swooning12278203s_wooning
syphoning1845393syphoning
teaseling1036913teaseling
teasing83918513teas__ing
tenoning938893te_noning
tensioning1144983tensioning
unreasoning1242973unreasoning
wagoning1336923_wagoning
weakening1734843weakening
weaning114117193wea__ning
weaseling1335613weaseling
yeaning113814633yea__ning
yearning1296983yea_rning
yeasting12188923yeas_ting

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 Filter1786911486410.1701051123.5
2DLD Change Limit1486411177.30020361.8
3Display Results1171170.0601950.0
 (SQL Overall)1786911177.53023730.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.