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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

85 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
instigative155512(None) 
initiative1346902initi_ative
instigate1048612instigat__e
instigating1347152instigating
instigation1249242instigation
instinctive1654372instinctive
investigative2062632investigative
estimative1546483_estimative
indicative1647713in_dicative
initiatives1444283initi_atives
insinuative1454023insinuative
instigated1247693instigat_ed
instigates1148423instigat_es
instigations1348243instigations
instigator1146413instigat_or
instigators1245923instigators
instructive1656483instructive
integrative1547123in_tegrative
mitigative1644093_mitigative
castigate1247964castigat__e
castigating1546004castigating
castigation1447974castigation
colligative1754354colligative
constative15410104const__ative
constitutive1754104constitutive
designative1654334des_ignative
dissipative1753814dissipative
distinctive1754934distinctive
enstatite946194enst__atite
fustigate1345624fustigat__e
fustigating1654054fustigating
fustigation1545214fustigation
gestative1347304gest__ative
gustative1345684gust__ative
imaginative1753844imaginative
imitative1446334i__mitative
implicative2054664implicative
inattentive1452564inattentive
inchoative1854044in_choative
incubative1745584in_cubative
indicatives1745124in_dicatives
indistinctive1992284indistinctive
indurative1447284in_durative
infinitive1645344in_finitive
inflictive18104634infli_ctive
informative1965154informative
inhibitive1854044in_hibitive
initialize1996864initi_alize
initiate8412694initi_at__e
initiating1149624initi_ating
initiation10412104initi_ation
innovative1643714in_novative
inoculative1655254inoculative
inoperative1646744inoperative
inquisitive2383194inquisitive
insatiate948064insati_at__e
inscriptive1853844inscriptive
insensitive1454814insensitive
inspective1746404ins_pective
inspiration1348374inspiration
instate71616484inst__at__e
instating10812214inst__ating
instillation1245854instillation
instinctively2153084instinctively
institute946444insti__tute
instituting1244804instituting
institution1145294institution
interactive1659634in_teractive
intimate101013834in_timat__e
intimating13410824in_timating
intimation12413044in_timation
intuitive1246164in_t_uitive
investigate15104304investigat__e
investigating1853344investigating
investigation1754084investigation
irritative1345204i_rritative
iterative12410714i__terative
ligative1258804___ligative
motivative1844284_motivative
negative1239084_n__egative
nominative1597684_nominative
restorative1446944restorative
stative102612934__st__ative
stigmatize2254034__stigmatize
vindicative2053794vin_dicative

Search took 9 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 Filter1786911488190.423422437.4
2DLD Change Limit148819858.40317710.2
3Display Results85850.0501700.0
 (SQL Overall)178691858.87620131.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.