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

131 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
absenting123699(None) 
assenting1038161assenting
abetting1158292ab_etting
abseiling1265342abseiling
accenting1487822accenting
agenting1039382a_genting
asserting1038662asserting
resenting102619292resenting
abating10413973ab__ating
abducting1584083abducting
abegging1334483ab_egging
ablating11312003ab_lating
abnegating1444463abnegating
aborning1188003aborn_ing
aborting11710253ab_orting
abounding1335193abounding
abreacting1544533abreacting
abscessing1543323abscessing
abscising1444943abscising
absconding1642993absconding
absent84016993absent___
absented1156613absent_ed
absentee1067663absent_ee
absentees1164533absentees
absenter1086773absent_er
absenters1156173absenters
absently1345813absent_ly
absents93510723absent__s
absolving1543323absolving
absorbing1444483absorbing
abstention1254393abstention
abstentions1364373abstentions
absterging1453353absterging
abutting1137003ab_utting
accepting1695803accepting
advecting1645113advecting
adverting1437223adverting
affecting1845233affecting
agentings1134443a_gentings
alerting91312383a_lerting
alienating1147233alienating
aliening91510893alien_ing
alimenting1344503alimenting
amending12308913a_mending
amounting1236643amounting
anointing1038623anointing
anting75827023a___nting
appending1536283appending
argentine1047893argentine
arointing1049363arointing
aroynting1344633aroynting
arresting1038633arresting
asbestine1144883asbestine
ascending1336283ascending
assentive1245743assentive
assessing1045173assessing
assisting1046183assisting
assorting1037303assorting
attending11136373attending
attesting1036383attesting
augmenting1443853augmenting
avenging1345863a_venging
averting122512733a_verting
basseting1236153basseting
bassetting1344633bassetting
basting104227203bas__ting
beating104326873_b_eating
belting104119133_b_elting
bending114420893_b_ending
besetting12268423besetting
besting104923923_b_esting
betting103921403_b_etting
bisecting1436973bisecting
bleating113514503_bleating
blending12249963_blending
blunting11319843_blunting
bunting103718833_b_unting
caseating12311743caseating
cementing1438763cementing
consenting13313223consenting
dementing13311043dementing
denting94422183__denting
deserting11713143deserting
dissenting121310293dissenting
exsecting1935933exsecting
exserting1736663exserting
fomenting1537233fomenting
garmenting1445483garmenting
henting113719653__henting
incenting12912063incenting
indenting11911263indenting
inserting10914243inserting
insetting1079283insetting
inventing13109973inventing
lamenting1237703lamenting
margenting1446153margenting
miseating121215433miseating
nauseating1144983nauseating
objecting2144053objecting
observing1544393observing
obsessing1244263obsessing
obtesting1245883obtesting
obverting1536303obverting
orienting1038723orienting
parenting12611583parenting
patenting1248943patenting
presenting131013023presenting
rabbeting1445183rabbe_ting
relenting102716773relenting
renting84026853__renting
repenting122316553repenting
rerenting102617663rerenting
reseating102421533reseating
resecting122816483resecting
resending112313363resending
resetting102816293resetting
scenting113212813_scenting
seating84130683__seating
sending94221373__sending
sensing84116953__sensing
setting83621393__setting
sklenting1475123sklenting
tableting1236353table_ting
tabletting1344093tabletting
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.406440125.6
2DLD Change Limit1486411317.57619620.0
3Display Results1311310.0632079.4
 (SQL Overall)1786911318.04522211.4
 
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.