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

147 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
reactive1331047(None) 
active11313742__active
coactive1598622coactive
creative132812802crea_tive
enactive1338512enactive
erective13311832erective
inactive1348202inactive
orective1339352ore_ctive
precative16312572precative
proactive1648362proactive
reacting113317892reacting
reaction10612602reaction
reactivate1545842reactivate
reactively1845882reactively
receive1239732re_ceive
reductive1547792reductive
refective1749112refective
refractive1846692refractive
rejective2148252rejective
relative11313142relative
restive10315932re_stive
tractive13310042tractive
actives12311523__actives
adaptive1445133adaptive
amative12311733ama_tive
beastie92412433beasti_e
bioactive1644133bioactive
captive1438973_captive
creatine103417413crea_tine
creatives14279693crea_tives
crescive1545283cresc_ive
dative10311813_da_tive
deactivate1644623deactivate
deceive1337813de_ceive
decoctive1745863decoctive
deductive1645473deductive
defective1848003defective
denotive1238673denotive
detective1548103detective
detractive1647373detractive
directive1557773dire_ctive
dreamtime1442343dreamtime
eductive1476863eductive
ejective2037153ejective
elative10312453_elative
elective13311003elective
emotive1239193_emotive
erectile1039513erectile
ergative1238973ergative
eruptive1345793eruptive
exaptive2045253exaptive
festive1339773fe_stive
fictive1537023_fictive
fricative1746743fricative
genitive1247643genitive
ideative1238573idea_tive
impactive1845283impactive
lenitive1148493lenitive
locative1338683locative
mealtime1245123mealtime
meantime1245983meantime
native9613013_na_tive
negative1239083negative
nonactive1448973nonactive
nonreactive1645953nonreactive
olfactive1743463olfactive
overactive1847263overactive
peacetime1544473peacetime
pectize20259913pe_ctize
perceive1546973perceive
placative1646223placative
practice1438733practice
practise12310143practise
preacting142412533preacting
predictive1847423predictive
ragtime1036163r_agtime
ratine65131823r_a_tine
ratite65022423r_a_tite
reaccede1354363reaccede
reaccuse1245043reaccuse
reaching143317203reaching
reacquire2043053reacquire
react74634333react___
reactance1346353reactance
reactant10311433reactant
reacted103015713react_ed
reactions11711713reactions
reactivated1744973reactivated
reactivates1645613reactivates
reactivity1845393reactivity
reactor93011653react_or
reactors103212283reactors
reacts83616603react__s
realise73021813rea_lise
realize162717083rea_lize
realties8514853realties
rearmice1255213rearmice
reave84528023rea___ve
rebaptize2293373rebaptize
received1437983re_ceived
receiver1337413re_ceiver
receives1339743re_ceives
receptive1648323receptive
recipe103414893re_c_ipe
recite83625113re_c_ite
recline94020493re_cline
recti73619623re_cti__
rectify1536453re_ctify
recurve1237403re_curve
redacting13612303redacting
redaction1259663redaction
redrive112410563re_drive
reflective1857123reflective
refractile1544143refractile
regive104814323re__give
reive85522943re___ive
relatives1239963relatives
relive95120783re__live
reparative1548173reparative
reptile93914083re_ptile
resentive12410723resentive
resistive1247583resistive
respective1747623respective
restrive11310923restrive
retentive1249853retentive
retie55735303re__ti_e
retile65929673re__tile
retime85321803re__time
retine66237333re__tine
retire64927013re__tire
retractile1246253retractile
retroactive1645823retroactive
revertive1548853revertive
revive124914823re__vive
rotative11310343rotative
sectile9311973se_ctile
sedative1238853sedative
seductive1545613seductive
selective1449523selective
stative102612933sta_tive
tactile9310613_tactile
teatime9310083tea_time
tectite9310583te_ctite
tractile10311073tractile
treatise8311103trea_tise
vegetive1545543vegetive
vocative1637913vocative

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 Filter1786911461620.423422437.4
2DLD Change Limit1461621476.57622226.6
3Display Results1471470.0632333.3
 (SQL Overall)1786911477.06225303.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.