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

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

126 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
preventatives215293(None) 
preventative2054311preventative_
presentative1755342presentative_
preventives1945722preven__tives
frequentatives29141363frequentatives
presentations1548133presentations
preservatives2152783preservatives
preventive1847543preven__tive_
representatives20211893representatives
augmentatives1961934augmentatives
deverbatives2152174_deverbatives
fermentative20113894fermentative_
frequentative28131764frequentative_
prebendaries1752814prebendari_es
premeditative2162914premeditative_
preparatives1954444pre_paratives
prerogatives1853434pre_rogatives
presentation1448994presentati_on
preservative2053954preservative_
preventable1844984preventa_ble_
preventions1648534preven__tions
preventively2354704preven__tively
privatives18186474priv___atives
provocatives2253374prov_ocatives
recitatives1645194_re_citatives
representative19192314representative_
tentatives1345484___tentatives
adventives1745125_adven__tives
adversatives1952475_adversatives
argumentative1962265argumentative_
augmentative1852715augmentative_
brevetcies1782205breve_t_ci_es
cementations1659015_cementations
creatives14279695cr__e__atives
devastative1853435_devastative_
deverbative2053625_deverbative_
edentates1046955__edentat__es
eventides1345795__even__tides
eventuates1394185__eventuat__es
fermentations1856275fermentations
frequentations2652245frequentations
gravitative1852975grav_itative_
orientalizes2175755or_ientalizes
orientates1046045or_ientat__es
orientations1246915or_ientations
pejoratives2353505p_e_joratives
pendentives1753675penden__tives
penetrative1646115p_enetrative_
percentages1653425percenta__ges
percentiles1546205percen__tiles
perennates1256765p_erennat__es
perennations1447255p_erennations
perfectives2145465perfe__ctives
performatives2392685performatives
permeative1748525perme__ative_
perseverative2162315perseve_rative_
personative1647075person_ative_
perversities1754455perversiti_es
pigmentations1854095pigmentations
placentations17103635placentations
potentates12106335p_otentat__es
precative16312575pr__e_cative_
preceptive1947765prece__ptive_
preceptories1854955preceptori_es
precipitative2253605precipitative_
preconceives2152795precon_ceives
predestines1446995prede__stines
predicative1947375pre_dicative_
preemptive1944145pre_e_mptive_
premeditates1753755premeditat__es
premeditations1955015premeditations
prentices131111905pr__en__tices
preoperative1955755preoperative_
preparative1846355pre_parative_
prerogative1755355pre_rogative_
prerogatived1952635pre_rogatived
presentable1546035presenta_ble_
presentational1673215presentational
presentees1247925presen__t_ees
presentences1655695present_ences
presentisms1555215presen__tisms
presentnesses1554425presentnesses
preservations1895545preservations
presettles1245025prese_t_t_les
pretentious13125595preten__tious
pretties10615135pr__e_t_ti_es
preventability2464065preventability
prevented1539005preven__t__ed
preventer1438595preven__t__er
preventers1547395preven__t_ers
preventible1854425preven__tible
preventing161210265preven__ti_ng
prevention1549175preven__ti_on
preventiveness2294895preventiveness
prevents133012295preven__t___s
privatises15187405priv___atises
privative17188295priv___ative_
privatizes24156815priv___atizes
proletaries1348455prole_tari_es
propensities1655265propensiti_es
protestations1555815protestations
provenances1854535proven_a_nces
provocative2154645prov_ocative_
recantations1448875_recantations
recitative1548185_re_citative_
recitativos1652175_re_citativos
reentries9311765_re_ent_ri_es
regenerative1655305_regenerative_
relatives1239965_r__e_latives
repentances1556115_repenta_nces
repetitive1545405_repe_titive_
representations17153895representations
resensitizes2154405_resensitizes
resentive12410725_resen__tive_
restoratives1554155_restoratives
retentive1249855_reten__tive_
revegetates1553935_revegetat__es
revegetations17114715_revegetations
revelations14410305_reve_lations
revertive1548855_reve__rtive_
revitalises14115975_rev_italises
revitalizes23117695_rev_italizes
seventies1249675_seven__ti_es
sustentative15133105sustentative_
tentative1247815___tentative_
vegetative1744575_vege_tative_

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 Filter1786911247900.1401276364.3
2DLD Change Limit1247901269.37613309.5
3Display Results1261260.0761657.9
 (SQL Overall)1786911269.59218629.2
 
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.