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

103 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
precative1631257(None) 
creative132812802cre_ative
erective13311832erec_tive
fricative1746742fricative
orective1339352orec_tive
placative1646222placative
preceptive1947762preceptive
predicative1947372predicative
privative17188292privative
proactive1648362proactive
probative1649172probative
reactive13310472_reactive
relative11313142_relative
appreciative2153943appreciative
creatine103417413cre_atine
creatives14279693cre_atives
depreciative2084083depreciative
directive1557773direc_tive
educative15136553educative
ejective2037153ejec_tive
elative10312453__elative
elective13311003elec_tive
erectile1039513erec_tile
ergative1238973er_gative
evocative1746293evocative
execrative2246043execrative
executive2164743executive
fricatives1844683fricatives
ideative1238573ide_ative
irrelative1344783irrelative
iterative12410713iterative
locative1338683_locative
negative1239083_negative
operative141110553operative
pectize20259913p_ec_tize
percaline13410953percaline
perceive1546973perc_eive
perceptive1946803perceptive
perfective2047193perfec_tive
permeative1748523permeative
persecutive1853933persecutive
pervasive1744483pervasive
portative1449373portative
practice1438733prac_tice
practise12310143prac_tise
preacting142412533preacting
preadaptive1952913preadaptive
prebattle1343013prebattle
precasting15169833precasting
precatory1649113precatory
precaution1447243precaution
precava1445093preca__va
precavae1544813preca_vae
precipe133012123prec__ipe
precipice1745953precipice
precise113518173prec__ise
preclusive1753883preclusive
preconize2268633preconize
predate10616893predat__e
predating13514653predating
predation12313463predation
predatism1447283predatism
predictive1847423predictive
predive13511083pre__dive
preemptive1944143preemptive
prelate9519693prelat__e
prelatic12311293prelati_c
prelatism1347853prelatism
prelature1146273prelature
prelusive1455583prelusive
premature1347793premature
prentice121012353pre_ntice
preparative1846353preparative
prepave14228873prepa__ve
prerogative1755353prerogative
prestige11310733pre_stige
preventive1847543preventive
primitive1646393primitive
privatise14167763privatise
privatives18186473privatives
privatize23167043privatize
procaine12312273proca_ine
procreative1846313procreative
projective2446813projec_tive
promotive1648033promotive
protective1748423protec_tive
provocative2154643provocative
pulsative1455173pulsative
purgative1545283purgative
putative1348373p_utative
receive1239733_rec_eive
receptive1648323_receptive
recitative1548183_recitative
recreative1549023_recreative
relatives1239963_relatives
restive10315933_re_stive
rotative11310343_rotative
sedative1238853_sedative
siccative1645103siccative
tractive13310043trac_tive
treatise8311103tre_atise
urinative1247653urinative
vocative1637913_vocative

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.580308087.9
2DLD Change Limit1486411036.68622231.7
3Display Results1031030.0462239.1
 (SQL Overall)1786911037.31224438.0
 
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.