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

148 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
investing1311939(None) 
infesting13109511infesting
ingesting11129621ingesting
inventing13109971inventing
inverting131013221inverting
devesting14249902devesting
divesting14298482divesting
incenting12912062incenting
incepting1489292incepting
indenting11911262indenting
infecting15109672infecting
injecting1997692injecting
inletting1087872inletting
inmeshing1595332inmeshing
inserting10914232inserting
insetting1079282insetting
insisting1038822insisting
intestine9411852intestine
inversing1389622inversing
invertin11910232invertin_
invertins12911022invertins
inviting1239732inv_iting
nesting84320442_n_esting
reinvesting1545322reinvesting
revesting132814122revesting
unresting10311132unresting
vesting114618682__vesting
advecting1645113advecting
adverting1437223adverting
arresting1038633arresting
attesting1036383attesting
averting122512733_averting
besting104923923__besting
caveating1539293caveating
coinventing1744543coinventing
congesting14410113congesting
contesting13312213contesting
convecting18310433convecting
conventing16311543conventing
converting16313133converting
coveting141912303cove_ting
cresting114017043_cresting
detesting112610323detesting
digesting12208673digesting
disinvesting1754203disinvesting
diverting142410333diverting
egesting1039013_egesting
encysting1544613encysting
enlisting1038343enlisting
enmeshing15114873enmeshing
everting122213133_everting
finessing1345123fin_essing
foresting13311363foresting
guesting1058463_guesting
harvesting1744413harvesting
ideating10311703i_deating
immeshing17103463immeshing
impasting1436323impasting
imposting1436813imposting
inbeing1038333inbe__ing
incanting1289903incanting
incasing11610603incas_ing
incensing1297663incensing
incising11411093incis_ing
inciting11312533in_citing
incrusting13126473incrusting
incusing1159953incus_ing
indexing1737123inde_xing
indicting1339613indicting
inditing10312113in_diting
inducting1338373inducting
inferring1338613inferring
infestant1247233infestant
inflating13310443inflating
inflecting1646313inflecting
infusing1237893infus_ing
ingestion10137483ingestion
ingestions1197593ingestions
ingestive1347393ingestive
ingoting1039863in_goting
inhering12913713inhe_ring
inheriting1448853inheriting
innerving1346493innerving
inputting1235823inputting
inrushing1365503inrushing
inspecting1546223inspecting
instating10812213instating
insulting1038053insulting
intending1139983intending
interesting12411123interesting
interning10315253interning
interring10315423interring
intestinal1047513intestinal
intestines10410253intestines
intorting10311413intorting
intreating11614013intreating
intrusting11128173intrusting
intuiting1089613intuiting
intwisting1445063intwisting
invading1336263inv_ading
invective1798043invective
inveighing1842733inveighing
inveigling1542693inveigling
invention1248333invention
inventions1348313inventions
inventive1588043inventive
invest93014843invest___
invested12229693invest_ed
investment1567103investment
investor11247413invest_or
investors12227723investors
invests10319683invest__s
invocating1646333invocating
invoicing1545333invoicing
invoking1635653inv_oking
involuting1444613involuting
involving1644363involving
inweaving1644773inweaving
jesting154317713__jesting
molesting1237753molesting
nestling958893_n_estling
netting84018763_n_etting
obtesting1245883obtesting
obverting1536303obverting
priesting1239483priesting
questing1838273_questing
reesting93118273_reesting
reinventing1545253reinventing
renesting102514703renesting
resting85031183__resting
retesting102614603retesting
reverting132315133reverting
revetting132912633revetting
riveting12139443rive_ting
rivetting13256413rivetting
testing86021053__testing
unbelting1237663unbelting
unmeshing1595933unmeshing
unseating10713203unseating
unsetting1088993unsetting
unveiling1337723unveiling
unweeting1336473unweeting
venting114218093__venting
vestings12359143__vestings
vetting114216563__vetting
westing115020273__westing
wresting123811833_wresting
zesting174515333__zesting

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.420425454.8
2DLD Change Limit1486411486.80021859.0
3Display Results1481480.0602466.7
 (SQL Overall)1786911487.28024545.5
 
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.