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

109 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
tasseling103585(None) 
tasselling1145231tasselling
basseting1236152basseting
detasseling1362202detasseling
hanseling1338062hanseling
hassling1236802hass_ling
rassling939012rass_ling
teaseling1036912teaseling
tinseling1036642tinseling
tussling935822tuss_ling
abseiling1265343_abseiling
aneling82719503_a_neling
angeling102811733_angeling
assailing1036023_assailing
assaying1236003_assaying
assembling1542883_assembling
assenting1038163_assenting
asserting1038663_asserting
assessing1045173_assessing
assoiling1045353_assoiling
assuming1135143_assuming
assuring937773_assuring
atheling1249203_atheling
barreling1238043barreling
baseline10310753ba_seline
bassetting1344633bassetting
busheling1535503busheling
cageling12310843ca_geling
canceling14310163canceling
capsuling1444533capsuling
casketing1635383casketing
castling11311233ca_stling
chasseing1554963chasse_ing
chiseling1536403chiseling
cosseting1239543cosseting
detasselling1451703detasselling
dieseling1146143dieseling
farseeing1344383farseeing
fastening13268603fastening
gassing94216333gass__ing
gaveling133410163ga_veling
gusseting1173963gusseting
handseling1544323handseling
hanselling1445623hanselling
hastening13259483hastening
hirseling1396273hirseling
hosteling1337893hosteling
houseling1337483houseling
kashering1736253kashering
labeling11311643la_beling
lassoing946383lass_oing
laureling1035643laureling
lessening1045333lessening
marveling1537103marveling
massaging1346353massaging
massing104318023mass__ing
mastering122315303mastering
morseling1238073morseling
paneling111013623pa_neling
parceling1438443parceling
passaging1345613passaging
passalong1242523passalong
passerine1147083passerine
passing104318423pass__ing
rappeling1435963rappeling
raveling123414373ra_veling
russeting1065323russeting
sassing84615553sass__ing
seeling83522003__seeling
starveling1444263starveling
tabering112211423ta_bering
tableting1236353tableting
tabling103216033ta__bling
tackling153211123ta_ckling
tailing82923103ta__iling
tampering1438453tampering
tangling101712543ta_ngling
tapeline10310363ta_peline
tapering112112503ta_pering
targeting1137303targeting
tasking124616323ta_s_king
tassel66014773tassel___
tasseled935593tassel_ed
tasselled1044633tasselled
tassels74510853tassel__s
tasting84624213ta_s_ting
tattering102212323tattering
tattling9259473ta_ttling
tautening1035843tautening
tawsing1138673taws__ing
teaselling1145333teaselling
teazeling1934543teazeling
tesselating1243843tesselating
tinselling1145523tinselling
tissuing935103tiss_uing
tossing83612563toss__ing
tousling938793tous_ling
toweling122910373t_oweling
trameling1249053trameling
trammeling1544023trammeling
traveling1349053traveling
troweling1376363troweling
tunneling1034693tunneling
vaseline1138613va_seline
warsling12198593wars_ling
warstling1335063warstling
wassailing1443593wassailing
weaseling1335613weaseling
wrassling1334273wrass_ling

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.423422437.4
2DLD Change Limit1486411097.45319943.8
3Display Results1091090.0462369.6
 (SQL Overall)1786911097.92222556.3
 
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.