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

92 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
extractives235455(None) 
extractive2246601extractive_
extractions2077742extractions
extractively2754532extractively
attractive1545553attractive_
detractive1647373detractive_
extinctive2253453extinctive_
extracted1946723extract__ed
extracting2047223extracti_ng
extraction1967983extracti_on
extractors1946423extract_ors
extracts1747623extract___s
extradites1845573extra_dites
extralities1848233extralities
restrictives1755083restrictives
tractive13310043__tractive_
abstractive1854894abstractive_
actives12311524____actives
attractions1376404attractions
attractively2053584attractively
contractive1849524contractive_
correctives1845574correctives
curatives1437824_cura_tives
destructive1755694destructive_
detectives1645784det_ectives
detractions14118274detractions
detractively2154904detractively
directives1655834_directives
distractive1746774distractive_
duratives1346224_dura_tives
effectives21134564e_ffectives
ejectives2145444e__jectives
elatives1139784e__la_tives
electives1448934e__lectives
embracive1843854embrac_ive_
enactive1338514e__nactive_
entreaties1048114entreati_es
erective13311834e__rective_
ergatives1346444e__rgatives
eruptives1443854e__ruptives
exactions1838924ex__actions
exaptive2045254ex__aptive_
exarchies2145214exar_chi_es
excretive2145144excr_etive_
execrative2246044execra_tive_
executives2263164ex_ecutives
exercises1846464exer_c_ises
exertive1839084exer__tive_
exorcises1845694exor_c_ises
exorcizes2744254exor_c_izes
expletives2243354ex_pletives
extinctions2044634extinctions
extortive1945144ext_ortive_
extract16311014extract____
extractable2254154extractable
extractor1846724extract__or
extradite1746434extra_dite_
extradited1944414extra_dited
extraditions2054404extraditions
extradoses1853454extra_doses
extremities2053804extremities
extricates1998244extric_ates
extrications2149054extrications
extrusive1944804extr_usive_
exudative2044894exuda_tive_
hyperactives2555274hyperactives
interactive1659634interactive_
narratives1344794narra_tives
nutritives1344154nutr_itives
obstructives1953914obstructives
operatives15117884opera_tives
optatives1445204opt_a_tives
ostracises1245374ostrac_ises
ostracizes2144724ostrac_izes
overactive1847264overactive_
pejoratives2353504pejora_tives
practices1557994__practices
practises1349624__practises
protractive1855634protractive_
refractive1846694refractive_
restoratives1554154restora_tives
restrictive1646364restrictive_
retractile1246254retractile_
retractions13910354retractions
retroactive1645824retroactive_
statives112710794_st_a_tives
subtractive1854664subtractive_
tentatives1345484tent_a_tives
tetracaines1354094tetracaines
tractates1159764__tractates
tractile10311074__tractile_
tractions11511624__tractions

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 Filter1786911488190.453394461.4
2DLD Change Limit148819929.12616307.1
3Display Results92920.0631460.3
 (SQL Overall)178691929.64218532.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.