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

144 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
assenting103816(None) 
absenting1236991absenting
asserting1038661asserting
accenting1487832accenting
agenting1039382a_genting
ascending1336282ascending
assentive1245742assentive
assessing1045172assessing
assisting1046182assisting
assorting1037302assorting
basseting1236152basse_ting
bassetting1344632bassetting
dissenting121310292dissenting
resenting102619292resenting
scenting113212812_scenting
abetting1158293a_betting
abseiling1265343abseiling
accepting1695823accepting
advecting1645113advecting
adverting1437223adverting
affecting1845233affecting
agentings1134443a_gentings
alerting91312383a_lerting
alienating1147233alienating
aliening91510893alien_ing
alimenting1344503alimenting
amending12308913a_mending
amounting1236643amounting
anointing1038623anointing
anting75827023a___nting
appending1536283appending
argentine1047893argentine
arointing1049363arointing
aroynting1344633aroynting
arresting1038633arresting
asbestine1144883asbestine
asperating1349563asperating
aspersing1237603aspersing
assailing1036023assailing
assaulting1142923assaulting
assaying1236003ass_aying
assegaiing1241903assegaiing
assembling1542883assembling
assent65119953assent___
assented957523assent_ed
assenter867713assent_er
assenters967003assenters
assentor865293assent_or
assentors955663assentors
assents74512223assent__s
assertion946723assertion
assertions1046583assertions
assertive1246473assertive
assigning1144673assigning
assoiling1045353assoiling
assuaging1144123assuaging
assuming1135143ass_uming
assuring937773ass_uring
asswaging1443103asswaging
astonying1345233astonying
attending11136373attending
attesting1036383attesting
augmenting1443853augmenting
avenging1345863a_venging
averting122512733a_verting
besetting12268423besetting
bisecting1436973bisecting
caseating12311743caseating
casketing1635383caske_ting
cementing1438763cementing
consenting13313223consenting
cosseting1239543cosse_ting
dementing13311043dementing
denting94422183__denting
deserting11713143deserting
disseating121111783disseating
dissecting14139473dissecting
disserting121310853disserting
essential946083essential
exsecting1935933exsecting
exserting1736663exserting
fastening13268603fasten_ing
fomenting1537233fomenting
garmenting1445493garmenting
gusseting1173963gusse_ting
hastening13259483hasten_ing
henting113719653__henting
incenting12912063incenting
indenting11911263indenting
inserting10914243inserting
insetting1079283insetting
inventing13109973inventing
lamenting1237703lamenting
lessening1045333lessen_ing
margenting1446153margenting
miseating121215433miseating
misseating131310943misseating
missending1446493missending
missetting13107903missetting
nauseating1144983nauseating
orienting1038723orienting
parenting12611583parenting
patenting1248953patenting
presenting131013023presenting
reasserting1246153reasserting
relenting102716773relenting
renting84026853__renting
repenting122316553repenting
rerenting102617663rerenting
reseating102421533reseating
resecting122816483resecting
resending112313363resending
resetting102816293resetting
russeting1065323russe_ting
russetting1184253russetting
sainting93215733_sainting
scanting113914763_scanting
scending122610583_scending
seating84130683__seating
sending94221373__sending
sensing84116953__sensing
setting83621393__setting
sheeting122712833_sheeting
shending132511253_shending
shunting123610433_shunting
sklenting1475123sklenting
slanting94115093_slanting
sleeting93114163_sleeting
smelting11339713_smelting
spending122712433_spending
stetting93410713_stetting
stinting93415743_stinting
stunting92811503_stunting
sweating123213023_sweating
sweeting123911313_sweeting
tasseling1035853tasse_ling
tasselling1145233tasselling
tenting84621153__tenting
unseating10713203unseating
unsetting1088993unsetting
upsending1334903upsending
upsetting1275563upsetting
venting114218093__venting
wadsetting1542913wadsetting

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 Filter1786911486410.420425454.8
2DLD Change Limit1486411448.19018149.1
3Display Results1441440.0602400.0
 (SQL Overall)1786911448.67020610.3
 
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.