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 “injectants” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

106 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
injectants194328(None) 
injectant1845291injectant_
infectant1446832infectant_
infestants1344502infestants
expectants2163583expectants
humectants1751953humectants
incants92012803in__c_ants
incitants1196193in_citants
indicants1247203indic_ants
infestant1247233infestant_
injectable2147003injectable
injectables2252813injectables
injecting1997693injectin_g
injections1948663injections
injectors18216723inject_ors
injects16257453injec___ts
insectan1045393insectan__
instants8910153in__stants
integrants1146693integrants
intendants1145253intendants
interactants1464503interactants
adjutants1772914adj_utants
annuitants1052634annuitants
arrestants1044324arrestants
attestants1053904attestants
contestants1356804contestants
cosecants1346534cosec_ants
decants103514444__dec_ants
disinfectants1972374disinfectants
ejectments2144054_ejectments
enchants1347834en__chants
executants1952694_executants
expectant2045674expectant_
exsecants1893404exsec_ants
humectant1653374humectant_
impeccant1743614impeccant_
incant82418514in__c_ant_
incents92414534in__c_ents
incessant1146094incessant_
incitant10810084in_citant_
indecent11411274indec_ent_
indents83114664inde___nts
indicans1147664indic_an_s
indicant11410344indic_ant_
indictments1654404indictments
inductance1563934inductance
inductances1663514inductances
inebriants1243874inebriants
inerrant8412494in_errant_
infants102210774in___fants
infecters14257584infect_ers
infecting15109674infectin_g
infections15510234infections
infectious1545604infectious
infectors14218554infect_ors
infects12279714infec___ts
informants1544634informants
inhabitants1682614inhabitants
inhalants1244474in_halants
inject153210234injec___t_
injected18226754inject__ed
injection1838654inject_ion
injective2178024inject_ive
injector17236934inject__or
inkstands1443194in_kstands
innocents1145314innoc_ents
inoculants1244644inoculants
insectaries1354894insectaries
insectary1444214insecta_ry
insects93710844insec___ts
instant7815354in__stant_
insulants946914in_sulants
insurants947654in_surants
integrands1244124integrands
integrant1049834integrant_
intendant1047714intendant_
intents72115704in___tents
interactant1357044interactant_
interacts11312124inte_racts
intermats111412454interma_ts
interments12716214interments
interplants13116754interplants
intestate9159874intesta_te
intestates10159434intestates
intestines10410254intestines
intrants8312864in__trants
intrigants1145054intrigants
invariants1374084invariants
invectives1885904invectives
invents102812054inve___nts
invertases1345784invertases
invertins12911024invertin_s
investments1665904investments
irritants944614i_rritants
isooctanes1253114isooctanes
nectars938464_n_ecta_rs
octants9128734___octants
protectants1554364protectants
reactants1146624_reactants
recants93217094__rec_ants
reductants1344244reductants
revertants13124954revertants
secants93413894__sec_ants
sextants15287384__sextants
underpants1346914underpants
undertints1148284undertints

Search took 10 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 Filter1786911614500.453394461.4
2DLD Change Limit1614501069.29617367.7
3Display Results1061060.0502120.0
 (SQL Overall)1786911069.79918235.6
 
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.