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

139 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
ingesting1112962(None) 
infesting13109511infesting
investing13119391investing
congesting14410112congesting
digesting12208672digesting
egesting1039012_egesting
incenting12912062incenting
incepting1489292incepting
indenting11911262indenting
infecting15109672infecting
ingestion10137482ingestion
ingestions1197592ingestions
ingestive1347392ingestive
ingoting1039862ing_oting
injecting1997692injecting
inletting1087872inletting
inmeshing1595332inmeshing
inserting10914242inserting
insetting1079282insetting
insisting1038822insisting
intestine9411852intestine
inventing13109972inventing
inverting131013222inverting
nesting84320442_n_esting
unresting10311132unresting
agenting1039383_agenting
agisting1038243_agisting
angeling102811733ange_ling
angering102113803ange_ring
arresting1038633arresting
attesting1036383attesting
begetting13186583begetting
besting104923923__besting
bingeing12237643binge__ing
contesting13312213contesting
cresting114017043_cresting
degusting1236163degusting
detesting112610323detesting
devesting14249903devesting
disgusting1345963disgusting
divesting14298483divesting
encysting1544613encysting
enlisting1038343enlisting
enmeshing15114873enmeshing
fidgeting1544523fidge_ting
finessing1345123fin_essing
fingering1439193finge_ring
fingerling1544833fingerling
foresting13311363foresting
gasting95022763__gasting
getting93316563__getting
gingering1238873ginge_ring
guesting1058463_guesting
gusting93917163__gusting
ideating10311703i_deating
igniting1037363i_gniting
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
ingest73119003ingest___
ingesta8357863ingest__a
ingested10259003ingest_ed
ingestible1346333ingestible
ingests83210983ingest__s
ingoing9311023ing__oing
ingrafting1544893ingrafting
ingrowing1445533ingrowing
ingulfing1443873ingulfing
inhering12913713inhe_ring
inheriting1448853inheriting
innerving1346503innerving
inputting1235823inputting
inrushing1365503inrushing
inspecting1546223inspecting
instating10812213instating
insulting1038053insulting
intending1139983intending
interesting12411123interesting
interning10315253interning
interring10315423interring
intestinal1047513intestinal
intestines10410253intestines
intorting10311413intorting
intreating11614013intreating
intrusting11128173intrusting
intuiting1089613intuiting
intwisting1445063intwisting
inversing1389623inversing
invertin11910233invertin_
invertins12911023invertins
inviting1239733in_viting
inweaving1644773inweaving
jesting154317713__jesting
lingering11310513linge_ring
molesting1237753molesting
negating102012833_negating
nestling958893_n_estling
netting84018763_n_etting
obtesting1245883obtesting
priesting1239483priesting
questing1838273_questing
reesting93118273_reesting
reinvesting1545323reinvesting
renesting102514703renesting
resting85031183__resting
retesting102614603retesting
revesting132814123revesting
signeting1136223signe_ting
singeing10209933singe__ing
suggesting1343593suggesting
testing86021053__testing
tingeing10198553tinge__ing
unbelting1237663unbelting
unmeshing1595933unmeshing
unseating10713203unseating
unsetting1088993unsetting
unweeting1336473unweeting
vesting114618683__vesting
vignetting1542823vignetting
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.436409841.7
2DLD Change Limit1486411396.59322545.3
3Display Results1391390.0632206.3
 (SQL Overall)1786911397.09225196.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.