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

151 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
infesting1310951(None) 
infecting15109671infecting
ingesting11129621ingesting
investing13119391investing
incenting12912062incenting
incepting1489292incepting
indenting11911262indenting
inferring1338612inferring
infestant1247232infestant
inflating13310442inflating
inflecting1646312inflecting
infusing1237892infus_ing
injecting1997692injecting
inletting1087872inletting
inmeshing1595332inmeshing
inserting10914242inserting
insetting1079282insetting
insisting1038822insisting
intestine9411852intestine
inventing13109972inventing
inverting131013222inverting
nesting84320442_n_esting
unresting10311132unresting
affecting1845233affecting
arresting1038633arresting
attesting1036383attesting
besting104923923__besting
coinfecting1944573coinfecting
confecting18310553confecting
confessing1647183confessing
congesting14410113congesting
contesting13312213contesting
cresting114017043_cresting
defeating142311973defeating
defecting162510223defecting
detesting112610323detesting
devesting14249903devesting
digesting12208673digesting
disinfesting1754433disinfesting
divesting14298483divesting
effecting1845583effecting
egesting1039013_egesting
encysting1544613encysting
enlisting1038343enlisting
enmeshing15114873enmeshing
fasting114522833__fasting
feasting122011323__feasting
felting113515213__felting
fessing113812863__fessing
feting104417793__fe_ting
fetting113517873__fetting
finessing1345123fin_essing
fisting113818123__fisting
foresting13311363foresting
guesting1058463_guesting
ideating10311703i_deating
immeshing17103463immeshing
impasting1436323impasting
imposting1436813imposting
inbeing1038333inbe__ing
incanting1289903incanting
incasing11610603incas_ing
incensing1297663incensing
incising11411093incis_ing
inciting11312533in_citing
incrusting13126473incrusting
incusing1159953incus_ing
indexing1737123inde_xing
indicting1339613indicting
inditing10312113in_diting
inducting1338373inducting
infalling1356243infalling
infantine1247143infantine
infectant1446833infectant
infection14410473infection
infections15510233infections
infective17108973infective
infeoffing1641663infeoffing
infertile1248673infertile
infest93315433infest___
infestants1344503infestants
infested12249643infest_ed
infester11239433infest_er
infesters12237713infesters
infests10279793infest__s
infighting1844413infighting
infirming1545163infirming
infixing1936103inf_ixing
inflaming1546263inflaming
inflicting1645723inflicting
infolding1445413infolding
informing1537023informing
infracting1647353infracting
ingestion10137483ingestion
ingestions1197593ingestions
ingestive1347393ingestive
ingoting1039863in_goting
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
manifesting1762733manifesting
molesting1237753molesting
nestling958893_n_estling
netting84018763_n_etting
obtesting1245883obtesting
priesting1239483priesting
questing1838273_questing
reesting93118273_reesting
refecting152413353refecting
reinfecting1745153reinfecting
reinvesting1545323reinvesting
renesting102514703renesting
resting85031183__resting
retesting102614603retesting
revesting132814123revesting
testing86021053__testing
unbelting1237663unbelting
unfearing1338883unfearing
unfeeling1337113unfeeling
unfencing1545953unfencing
unfitting1336423unfitting
unmeshing1595933unmeshing
unseating10713203unseating
unsetting1088993unsetting
unweeting1336473unweeting
vesting114618683__vesting
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.423422437.4
2DLD Change Limit1486411516.51322822.2
3Display Results1511510.0632396.8
 (SQL Overall)1786911516.99925530.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.