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

146 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
asserting103866(None) 
assenting1038161assenting
assorting1037301assorting
absenting1236992absenting
adverting1437222adverting
alerting91312382a_lerting
asperating1349562asperating
aspersing1237602aspersing
assertion946722assertion
assertions1046582assertions
assertive1246472assertive
assessing1045172assessing
assisting1046182assisting
assuring937772assur_ing
averting122512732a_verting
basseting1236152basse_ting
bassetting1344632bassetting
deserting11713142deserting
disserting121310852disserting
exserting1736662exserting
inserting10914242inserting
reasserting1246152reasserting
abetting1158293a_betting
aborting11710253a_borting
abseiling1265343abseiling
absorbing1444483absorbing
absterging1453353absterging
accenting1487823accenting
accepting1695803accepting
accreting1446333accreting
acierating1348323acierating
adhering1338883adher_ing
adsorbing1344123adsorbing
advecting1645113advecting
aerating92821003a__erating
affecting1845233affecting
agenting1039383a_genting
airting83616303a__irting
altering91917113alter_ing
amercing1337193a_mercing
angering102113803anger_ing
anserine8313093anser_ine
answering1345803answer_ing
arresting1038633arresting
asbestine1144883asbestine
ascending1336283ascending
ascertain1144233ascertain_
ascertains1244263ascertains
ashlering1344153ashler_ing
aspirating1348363aspirating
aspiring1138873aspir_ing
assailing1036023assailing
assaulting1142923assaulting
assaying1236003ass_aying
assegaiing1241903assegaiing
assembling1542883assembling
assentive1245743assentive
assert64922583assert___
asserted957903assert_ed
asserter877573assert_er
asserters956393asserters
assertor865723assert_or
assertors965973assertors
asserts74311793assert__s
asseverating1652273asseverating
assigning1144673assigning
assoiling1045353assoiling
assuaging1144123assuaging
assuming1135143ass_uming
asswaging1443103asswaging
attesting1036383attesting
averring12239063a_verring
besetting12268423besetting
bisecting1436973bisecting
caseating12311743caseating
casketing1635383caske_ting
cosseting1239543cosse_ting
deserving1497903deserving
disseating121111783disseating
dissecting14139473dissecting
dissenting121310293dissenting
disserving15117013disserving
diverting142410333diverting
enserfing1345893enserfing
escorting1237713escorting
everting122213133_everting
exerting162211153_exerting
experting1938053experting
exsecting1935933exsecting
gusseting1173963gusse_ting
insetting1079283insetting
inverting131013223inverting
kashering1736253kasher_ing
mastering122315303master_ing
miseating121215433miseating
misseating131310943misseating
missetting13107903missetting
missorting1347123missorting
nauseating1144983nauseating
observing1544393observing
obverting1536303obverting
passerine1147083passer_ine
reassorting1245023reassorting
reseating102421533reseating
resecting122816483resecting
resenting102619293resenting
reserving131110643reserving
resetting102816293resetting
resorting10614613resorting
reverting132315133reverting
russeting1065323russe_ting
russetting1184253russetting
sabering112113743saber_ing
scarting113415263_scarting
scenting113212813_scenting
seating84130683__seating
serging93416673__serging
sering74731813__ser_ing
serving113014983__serving
setting83621393__setting
sheeting122712833_sheeting
shirting123213613_shirting
shorting122514803_shorting
skirting13289393_skirting
sleeting93114163_sleeting
smarting113212453_smarting
smelting11339713_smelting
smerking15258473_smerking
snorting92613373_snorting
sorting83221813__sorting
spirting112913633_spirting
sporting112415463_sporting
spurting113111633_spurting
starting93116173_starting
sterling93615553_sterling
stetting93410713_stetting
sweating123213023_sweating
sweeting123911313_sweeting
swerving1546113_swerving
tasseling1035853tasse_ling
tasselling1145233tasselling
unseating10713203unseating
unsetting1088993unsetting
upsetting1275563upsetting
ushering1258923usher_ing
wadsetting1542913wadsetting

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.546327272.9
2DLD Change Limit1486411466.61022487.3
3Display Results1461460.0602433.3
 (SQL Overall)1786911467.21624763.2
 
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.