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

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
orective133935(None) 
erective13311831erective
corrective1747442corrective
creative132812802creative
directive1557772directive
ejective2037152ejective
elective13311002elective
erectile1039512erectile
objective2345372objective
orectic1138822orecti_c
precative16312572precative
reactive13310472_reactive
receive1239732_receive
restive10315932_restive
tractive13310042tractive
active11313743__active
adjective2244813adjective
advective1845233advective
affective20135413affective
agentive1248043agentive
archive154610483ar_chive
arrestive1246753arrestive
bijective2343913bijective
coactive1598623coactive
coercive1545873coerc_ive
collective1747123collective
connective1749253connective
convective2049113convective
correctives1845573correctives
creatine103417413creatine
creatives14279693creatives
crescive1545283crescive
deceive1337813_deceive
defective1848003defective
detective1548103detective
directives1655833directives
eductive1476863eductive
effective2076193effective
egestive1246833egestive
ejectives2145443ejectives
electives1448933electives
enactive1338513enactive
erecting112415063erecting
erection102115513erection
ergative1238973ergative
eruptive1345793eruptive
executive2164743executive
exertive1839083exertive
festive1339773_festive
fictive1537023_fictive
foretime1348213fore_time
forgetive16124463forgetive
formative1747963formative
fricative1746743fricative
grecize1935663grec_ize
hortative1546433hortative
ideative1238573ideative
inactive1348203inactive
infective17108973infective
injective2178023injective
invective1798043invective
nonactive1448973nonactive
nonreactive1645953nonreactive
normative1448893normative
objectives2444533objectives
octave11157343o__ctave
olfactive1743463olfactive
onetime937623one_time
operative141110553operative
optative1347653optative
oreide7311673ore__ide
overactive1847263overactive
overlive142211293overlive
overtime131312273overtime
overtire111413113overtire
pectize20259913_pectize
perceive1546973perceive
perfective2047193perfective
portative1449373portative
practice1438733practice
practise12310143practise
preceptive1947763preceptive
precipe133012123prec_ipe
precise113518173prec_ise
predictive1847423predictive
predive13511083pre_dive
prentice121012353prentice
prestige11310733prestige
proactive1648363proactive
projective2446813projective
protective1748423protective
received1437983_received
receiver1337413_receiver
receives1339743_receives
receptive1648323_receptive
recipe103414893_rec_ipe
recite83625113_rec_ite
recline94020493_recline
recti73619623_recti__
rectify1536453_rectify
recurve1237403_recurve
redrive112410563_redrive
reductive1547793_reductive
refective1749113refective
regive104814323_re_give
reive85522943_re__ive
rejective2148253rejective
relative11313143_relative
relive95120783_re_live
reptile93914083_reptile
restrive11310923_restrive
retie55735303_re_ti_e
retile65929673_re_tile
retime85321803_re_time
retine66237333_re_tine
retire64927013_re_tire
revive124914823_re_vive
rotative11310343rotative
sectile9311973_sectile
selective1449523selective
smectite1245773smectite
sorptive1346473sor_ptive
surjective2244163surjective
tectite9310583_tectite
tractile10311073tractile
treatise8311103treatise

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 Limit1461621267.18620339.8
3Display Results1261260.0462739.1
 (SQL Overall)1786911267.65523343.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.