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

159 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
insetting107928(None) 
inletting1087871inletting
inserting10914231inserting
unsetting1088991unsetting
besetting12268422besetting
incenting12912062incenting
incepting1489292incepting
indenting11911262indenting
infecting15109672infecting
infesting13109512infesting
ingesting11129622ingesting
injecting1997692injecting
inputting1235822inputting
insisting1038822insisting
inspecting1546222inspecting
instating10812212instating
insulting1038052insulting
inventing13109972inventing
inverting131013222inverting
investing13119392investing
missetting13107902missetting
netting84018762_n_etting
resetting102816292resetting
setting83621392__setting
unseating10713202unseating
unsettling1144432unsettling
upsetting1275562upsetting
abetting1158293_abetting
absenting1236993absenting
assenting1038163assenting
asserting1038663asserting
bassetting1344633bassetting
begetting13186583begetting
besotting12256873besotting
betting103921403__betting
bisecting1436973bisecting
caseating12311743caseating
consenting13313213consenting
curetting1236573curetting
deserting11713143deserting
dipnetting1453623dipnetting
disseating121111783disseating
dissecting14139473dissecting
dissenting121310293dissenting
disserting121310853disserting
duetting1047183_duetting
enserfing1345893enserfing
exsecting1935933exsecting
exserting1736663exserting
facetting1535283facetting
fetting113517873__fetting
filmsetting1751873filmsetting
fretting122711523_fretting
gazetting2043243gazetting
getting93316563__getting
gibbetting1642313gibbetting
ideating10311703i_deating
inbeing1038333inbe__ing
incanting1289903incanting
incensing1297663incensing
inciting11312533in_citing
indexing1737123inde_xing
indicting1339613indicting
inditing10312113in_diting
inducting1338373inducting
inferring1338613inferring
inflating13310443inflating
inflecting1646313inflecting
ingoting1039863in_goting
inhering12913713inhe_ring
inheriting1448853inheriting
inmeshing1595333inmeshing
innerving1346493innerving
insectan1045383insectan_
insectile1147113insectile
insentient1049423insentient
insertion9410593insertion
insertions10410343insertions
insetted9249023insett_ed
insetter8218593insett_er
insetters9187133insetters
insheathing18102693insheathing
insnaring1046313insnaring
insolating1149153insolating
insouling1036823insouling
inspiring1246183inspiring
instituting1244803instituting
insulating1139263insulating
insuring9311153ins_uring
inswathing1742973inswathing
intending1139983intending
interning10315253interning
interring10315423interring
intestine9411853intestine
intitling1037213intitling
intorting10311413intorting
intreating11614013intreating
intuiting1089613intuiting
inversing1389623inversing
invertin11910233invertin_
invertins12911023invertins
inviting1239733in_viting
inweaving1644773inweaving
jetting153815343__jetting
knitting13257023kn_itting
knotting13236573kn_otting
letting83218533__letting
miseating121215433miseating
misseating131310943misseating
naething1236073_naething
nesting84320443_n_esting
nestling958893_nestling
nettings9288103_n_ettings
nettling957213_n_ettling
nonbetting1345843nonbetting
nutting83316233_n_utting
offsetting1742333offsetting
petting103720953__petting
pipetting1435513pipetting
presetting131010833presetting
reinserting1256903reinserting
reletting102713943reletting
reseating102421533reseating
resecting122816483resecting
resenting102619293resenting
resettling1135893resettling
resitting103414873resitting
retting83425883__retting
revetting132912633revetting
rewetting132710443rewetting
rivetting13256413rivetting
russetting1184253russetting
seating84130683__seating
settings93810073__settings
settling978943__settling
sitting83519633__sitting
sonnetting1144823sonnetting
stetting93410713_stetting
tinseling1036643tinse_ling
tinselling1145523tinselling
unbelting1237663unbelting
unfitting1336423unfitting
unhatting1335873unhatting
unresting10311133unresting
unsealing10711043unsealing
unseaming1278113unseaming
unseeing988293unse_eing
unselling10810333unselling
unsewing1287433unse_wing
unsexing1686853unse_xing
unstating10711213unstating
unstring9312093uns_tring
unweeting1336473unweeting
unwitting1335583unwitting
vetting114216563__vetting
vignetting1542823vignetting
wadsetting1542913wadsetting
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.403443402.0
2DLD Change Limit1486411596.94021418.0
3Display Results1591590.0632523.8
 (SQL Overall)1786911597.40624127.9
 
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.