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

145 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
inletting108787(None) 
insetting1079281insetting
incenting12912062incenting
incepting1489302incepting
indenting11911262indenting
infecting15109672infecting
infesting13109512infesting
inflecting1646312inflecting
ingesting11129622ingesting
injecting1997692injecting
inputting1235822inputting
inserting10914242inserting
inventing13109972inventing
inverting131013222inverting
investing13119392investing
letting83218532__letting
netting84018762_n_etting
reletting102713942reletting
unsetting1088992unsetting
abetting1158293_abetting
alerting91312383_alerting
allotting1046503allotting
begetting13186583begetting
besetting12268423besetting
betting103921403__betting
billeting1236643bille_ting
blatting114111653_blatting
bleating113514503_bleating
blotting113910433_blotting
cleating113518143_cleating
clefting14347583_clefting
clotting113110643_clotting
curetting1236573curetting
deleting103314423dele_ting
dipnetting1453623dipnetting
duetting1047183_duetting
electing112113783_electing
englutting1242723englutting
enlisting1038343enlisting
eyeletting1442873eyeletting
facetting1535283facetting
fetting113517873__fetting
fileting1239303file_ting
filleting1335853fille_ting
flatting123511253_flatting
fleeting122910323_fleeting
flitting123010883_flitting
fretting122711523_fretting
gazetting2043243gazetting
getting93316563__getting
gibbetting1642313gibbetting
gillnetting1351543gillnetting
gimleting1343863gimle_ting
gleeting10279173_gleeting
glutting10247643_glutting
ideating10311703i_deating
inbeing1038333inbe__ing
incanting1289903incanting
incensing1297663incensing
inciting11312533in_citing
indexing1737123inde_xing
indicting1339613indicting
inditing10312113in_diting
inducting1338373inducting
inferring1338613inferring
inflating13310443inflating
inflicting1645723inflicting
ingoting1039863in_goting
inhering12913713inhe_ring
inheriting1448853inheriting
inlacing1158373inl_acing
inlaying1247893inl_aying
inlying1168153inl__ying
inmeshing1595333inmeshing
innerving1346503innerving
insisting1038823insisting
inspecting1546223inspecting
instating10812213instating
insulting1038053insulting
intending1139983intending
interning10315253interning
interring10315423interring
intestine9411853intestine
intitling1037213intitling
intorting10311413intorting
intreating11614013intreating
intuiting1089613intuiting
inversing1389623inversing
invertin11910233invertin_
invertins12911023invertins
inviting1239733in_viting
inweaving1644773inweaving
jetting153815343__jetting
knitting13257023kn_itting
knotting13236573kn_otting
lotting82917753__lotting
missetting13107903missetting
molesting1237753molesting
naething1236073_naething
nesting84320443_n_esting
nettings9288103_n_ettings
nettling957213_n_ettling
nonbetting1345843nonbetting
nutting83316233_n_utting
petting103720953__petting
pipetting1435513pipetting
platting114813033_platting
pleating112916053_pleating
plotting113011013_plotting
relenting102716773relenting
resetting102816293resetting
retting83425883__retting
revetting132912633revetting
rewetting132710443rewetting
rivetting13256413rivetting
rouletting1144753rouletting
selecting12310533selecting
setting83621393__setting
sklenting1475123sklenting
slatting94014233_slatting
sleeting93114163_sleeting
slitting93012583_slitting
slotting92612613_slotting
sonnetting1144823sonnetting
splatting1235983splatting
splitting1236563splitting
stetting93410713_stetting
subletting1346273subletting
tabletting1344093tabletting
telnetting1143883telnetting
unbelting1237663unbelting
unfitting1336423unfitting
unhatting1335873unhatting
unleading1138673unleading
unresting10311133unresting
unseating10713203unseating
unsettling1144433unsettling
unweeting1336473unweeting
unwitting1335583unwitting
upsetting1275563upsetting
valeting1238853vale_ting
vetting114216563__vetting
vignetting1542823vignetting
wetting114117383__wetting
whetting1535973_whetting

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 Limit1486411457.22020587.4
3Display Results1451450.0761907.9
 (SQL Overall)1786911457.71923149.5
 
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.