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 “inventing” 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
inventing1310997(None) 
incenting12912061incenting
indenting11911261indenting
inverting131013221inverting
investing13119391investing
coinventing1744542coinventing
conventing16311552conventing
incanting1289902incanting
incensing1297662incensing
incepting1489302incepting
infecting15109672infecting
infesting13109512infesting
ingesting11129622ingesting
injecting1997692injecting
inletting1087872inletting
inserting10914242inserting
insetting1079282insetting
intending1139982intending
invention1248332invention
inventions1348312inventions
inventive1588042inventive
inversing1389622inversing
invertin11910232invertin_
invertins12911022invertins
inviting1239732inv_iting
reinventing1545252reinventing
venting114218092__venting
absenting1236993absenting
accenting1487833accenting
advecting1645113advecting
adverting1437223adverting
agenting1039383_agenting
anointing1038623anointing
assenting1038163assenting
avenging1345863_avenging
averting122512733_averting
caveating1539293caveating
cementing1438773cementing
consenting13313233consenting
contenting13313333contenting
convecting18310433convecting
convening15311213conven_ing
converting16313133converting
coveting141912323cove_ting
davening13258883daven_ing
dementing13311043dementing
denting94422183__denting
devesting14249903devesting
dissenting121310293dissenting
diverting142410333diverting
divesting14298483divesting
dovening13238373doven_ing
envenoming1642493envenoming
evening11310233_even_ing
everting122213133_everting
fomenting1537243fomenting
havening15258563haven_ing
henting113719653__henting
ideating10311703i_deating
impending1535933impending
inbeing1038333inbe__ing
incentive1489603incentive
inciting11312533in_citing
indention1049513indention
indentions1149063indentions
indenturing1342873indenturing
indexing1737123inde_xing
indicting1339613indicting
inditing10312113in_diting
inducting1338373inducting
infantine1247143infantine
inferring1338613inferring
inflating13310443inflating
inflecting1646313inflecting
ingoting1039863in_goting
inhering12913713inhe_ring
inheriting1448853inheriting
inmeshing1595333inmeshing
innerving1346503innerving
inning73617633in__n_ing
inputting1235823inputting
insentient1049423insentient
insisting1038823insisting
inspecting1546223inspecting
instating10812213instating
insulting1038053insulting
intention9412013intention
intentions10411403intentions
interning10315253interning
interring10315423interring
intestine9411863intestine
intonating1148633intonating
intoning9311123inton_ing
intorting10311423intorting
intreating11614013intreating
intuiting1089613intuiting
inurning937553inurn_ing
invading1336263inv_ading
invective1798043invective
inveighing1842733inveighing
inveigling1542693inveigling
invent93316363invent___
invented122510663invent_ed
inventer112410843invent_er
inventers12269533inventers
inventor11298153invent_or
inventors12288253inventors
inventory15255633inventory
inventorying1951283inventorying
invents102812053invent__s
invocating1646333invocating
invoicing1545333invoicing
invoking1635653inv_oking
involuting1444613involuting
involving1644363involving
inweaving1644773inweaving
inwinding1445173inwinding
lamenting1237703lamenting
levanting1345523levanting
livening12248163liven_ing
nesting84320443_n_esting
netting84018763_n_etting
obverting1536303obverting
orienting1038723orienting
parenting12611583parenting
patenting1248953patenting
pigmenting1653713pigmenting
pinkening1634993pinken_ing
preventing161210263preventing
ravening122611303raven_ing
reinvesting1545323reinvesting
relenting102716773relenting
renting84026853__renting
repenting122316553repenting
rerenting102617663rerenting
resenting102619293resenting
revenging1438083revenging
reverting132315133reverting
revesting132814123revesting
revetting132912633revetting
riveting12139443rive_ting
rivetting13256413rivetting
scenting113212813_scenting
sklenting1475123sklenting
tenting84621153__tenting
unbelting1237663unbelting
unbending1337463unbending
unending10239943un_ending
unfencing1545953unfencing
unpenning1236183unpenning
unresting10311133unresting
unseating10713203unseating
unsetting1088993unsetting
unveiling1337723unveiling
unweeting1336473unweeting
vending124015263__vending
venging123710943__venging
vesting114618683__vesting
vetting114216563__vetting

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.436409841.7
2DLD Change Limit1486411596.62322443.2
3Display Results1591590.0801987.5
 (SQL Overall)1786911597.13925030.3
 
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.