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

123 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
accurate1241066(None) 
acaudate1145972acaudate
accrete1137842acc_rete
accuracy1443602accuracy
accurately1752792accurately
accurst1146242accurst_
acerate92818912a_cerate
aciculate132510802aciculate
acierate10311812acierate
actuate9311442actu_ate
acuate8315632a_cu_ate
arcuate9311962arcu_ate
aurate64426472a__urate
curate85226242__curate
inaccurate1444332inaccurate
sacculate1349022sacculate
accelerate1444903accelerate
acclimate1546223acclimate
accolade1346043accolade
accreted1336333acc_reted
accretes1238113acc_retes
accruable1543603accruable
accrual1144553accrua_l
accruals1243703accruals
accrue1035823acc_r_ue
acculturate1554323acculturate
accumulate1653043accumulate
accuracies1353513accuracies
accursed1354633accursed
accusable1544873accusable
accusal11136003accusa_l
accusals12145053accusals
accusant1246863accusant
accusants1344283accusants
accusative1744443accusative
accuse103411033accu__se
acerated113113983a_cerated
acerbate1247533acerbate
acervate1336983acervate
acetate92514753a_cetate
aciculae12267703acicula_e
acidulate12256893acidulate
acierated1238283acierated
acierates11310793acierates
acrylate1347693acrylate
activate13510373activate
actuated1138743actu_ated
actuates10310303actu_ates
aculeate1039903aculeate
acute74720363a_cu__te
acylate12310533a_cylate
adulate8313223a_dulate
aerate64830553a__erate
ambulate1239733ambulate
ameerate1039633ameerate
amirate91115953a_mirate
amputate1246263amputate
angulate9312003angulate
annulate8310913annulate
apiculate13279883apiculate
arcuated1138803arcu_ated
ascorbate1344463ascorbate
asperate10312373asperate
aspirate1039943aspirate
aurae54128113a__ura_e
aurated83817793a__urated
aureate72515283a__ureate
azurite1638003a_zurite
baccarat1447933baccarat_
baccarats1544473baccarats
baccate131011263bacc__ate
calcarate1347703calcarate
calculate1389873calculate
canulate10314543canulate
carate84734003__carate
castrate10313863castrate
caudate10311353_caudate
cerate84829463__cerate
cirrate92413483_cirrate
citrate92216793_citrate
courage10310993_courage
courante1049953_courante
crate76537403__c_rate
curare84916953__curare
curated104717583__curated
curates95323823__curates
curite85222943__curite
curtate9312643__curtate
decorate11315193decorate
depurate1139983depurate
ecaudate1145313ecaudate
figurate1237183figurate
incubate1238663incubate
incudate1138873incudate
incurvate1446053incurvate
indurate9311873indurate
jaculate172311773jaculate
lacerate102214703lacerate
lacunate10128963lacunate
loculate101011403loculate
lucubrate1343373lucubrate
macerate122314073macerate
maculate122815613maculate
maturate10312613maturate
mercurate1347333mercurate
micturate1366643micturate
obdurate1175123obdurate
obturate1077773obturate
osculate101010613osculate
pandurate1245883pandurate
peculate122414663peculate
picrate112014143pic_rate
recrate92621643rec_rate
recurvate1445853recurvate
saccate111311763sacc__ate
sacculated1546623sacculated
saturate8312813saturate
scutate9310323_scutate
ulcerate1039733ulcerate
uncrate9415953unc_rate
urate55432163___urate
vaccinate1646833vaccinate
vicarate1378603vicarate

Search took 9 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.186960704.3
2DLD Change Limit1461621238.09318060.3
3Display Results1231230.0631952.4
 (SQL Overall)1786911238.34221420.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.