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

115 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
facetting153528(None) 
faceting1438781face_ting
abetting1158292_abetting
fatting113818702fa__tting
fetting113517872f__etting
fretting122711522f_retting
gazetting2043242gazetting
abutting1137003_abutting
accenting1487823accenting
accepting1695803accepting
acetin8314693_ace_tin_
acetins9313173_ace_tins
acting95920983_ac__ting
affecting1845233affecting
agenting1039383_agenting
alerting91312383_alerting
averting122512733_averting
bassetting1344633bassetting
batting104422273ba__tting
begetting13186583begetting
besetting12268423besetting
betting103921403__betting
cacheting1737153cacheting
caseating12311743caseating
catting103922643__catting
caveating1539293caveating
curetting1236573curetting
cutting103817493__cutting
duetting1047183_duetting
excepting2145873excepting
facelifting2052113facelifting
facetiae1346213face_tiae
facetted1445743facett_ed
facing125321573fac___ing
factoring1537523factoring
faggoting1543313faggoting
fagoting1336283fa_goting
fainting123312163fa_inting
faithing1537153fa_ithing
faltering132211113faltering
farthing1538073fa_rthing
farting114120753fa__rting
fastening13268603fastening
fasting114522833fa__sting
fating105328673fa___ting
fatling113815683fa__tling
fattening13287833fattening
faulting12237733fa_ulting
felting113515213f__elting
feting104417793f__e_ting
fettling1266773f__ettling
fileting1239303file_ting
fitting113516563f__itting
flatting123511253f_latting
fleeting122910323f_leeting
flitting123010883f_litting
fomenting1537233fomenting
foresting13311363foresting
forgetting1544663forgetting
fritting123510703f_ritting
garotting1136103garotting
gavotting1443193gavotting
getting93316563__getting
hatting113920233ha__tting
incenting12912063incenting
incepting1489293incepting
inletting1087873inletting
insetting1079283insetting
jacketing2345643jacketing
jetting153815343__jetting
lacerating1349443lacerating
lacewing1435843lace_wing
lactating1239183lactating
lamenting1237693lamenting
letting83218533__letting
macerating1549533macerating
matting103620143ma__tting
naething1236073na_ething
netting84018763__netting
offsetting1742333offsetting
pacesetting1652633pacesetting
packeting1836853packeting
parenting12611583parenting
pargetting1444943pargetting
patenting1248943patenting
patting103722343pa__tting
petting103720953__petting
pipetting1435513pipetting
racheting1537793racheting
racketing1647873racketing
ratting83822363ra__tting
recutting1239483recutting
reletting102713943reletting
resetting102816293resetting
retting83425883__retting
revetting132912633revetting
rewetting132710443rewetting
rivetting13256413rivetting
safetying1643073safetying
scatting113311813_scatting
scenting113212813_scenting
setting83621393__setting
stetting93410713_stetting
tabletting1344083tabletting
tatting84019523ta__tting
unsetting1088993unsetting
upsetting1275563upsetting
vacating14310353vac_ating
valeting1238843vale_ting
vatting113614853va__tting
vetting114216563__vetting
wadsetting1542913wadsetting
wetting114117383__wetting
whetting1535973_whetting
yachting1734933yac_hting

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.1731032896.0
2DLD Change Limit1486411157.56019661.5
3Display Results1151150.0502300.0
 (SQL Overall)1786911157.78322959.1
 
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.