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

118 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
acerbate124753(None) 
acerate92818911acer_ate
acerbated1465551acerbated
acerbates1347261acerbates
acervate1336981acervate
acerated113113982acer_ated
acerbity1544272acerbity
acetate92514752ace_tate
acierate10311812acier_ate
aerate64830552a_er_ate
ascorbate1344462ascorbate
cerate84829462_cer_ate
exacerbate21113372exacerbate
lacerate102214702lacer_ate
macerate122314072macer_ate
abate76627843a___bate
aberrated1245873aberrated
acarbose1244683acarbose
acaudate1145973acaudate
accrete1137843accr_ete
accurate12410663accurate
acerb9312763acerb___
acerbating1546293acerbating
acerber1135243acerb_er
acerbest1245463acerbest
acerbic1335643acerb_ic
acerbities1444973acerbities
acerose9310893acer_ose
acetated112010683ace_tated
acetates102013063ace_tates
acetylate1444213acetylate
acierated1238283acier_ated
acierates11310813acier_ates
acreage1037843ac_reage
acrobat11411813acrobat_
acrobats1258343acrobats
acrylate1347693acrylate
activate13510373activate
actuate9311443ac_tuate
acuate8315633ac__uate
aculeate1039923aculeate
acylate12310533ac_ylate
adequate1844303adequate
adsorbate1243183adsorbate
aerated85322373a_er_ated
aerates74627493a_er_ates
aerobat9514473a_erobat_
aerobats1049843a_erobats
agemate101210583age_mate
airdate8311323a_irdate
altercate1147853altercate
alternate948113alternate
amebae1049633ame_ba_e
ameerate1039633ameerate
amirate91115953amir_ate
approbate1546563approbate
arbute8311043a__rbute
areolate81014453areolate
ascorbates1444143ascorbates
asperate10312373asper_ate
aurate64426473a_ur_ate
aureate72515283a_ureate
average1158853aver_age
barbate11314543_barbate
berate84729023_ber_ate
carate84734003_car_ate
celibate1259313_celibate
cerated103922473_cer_ated
cerates95428253_cer_ates
cerebrate1348653_cerebrate
cerite84724873_cer_ite
cirrate92413493_cirrate
coacervate1763723coacervate
cordate10315223_cordate
crate76537403_c_r_ate
create85126383_c_reate
cremate113816183_cremate
crenate93317113_crenate
curate85226243_cur_ate
curtate9312643_curtate
debate94419193_de_bate
derate74531233_der_ate
enervate1148463enervate
ergate7315143__ergate
exacerbated23122703exacerbated
exacerbates22113063exacerbates
faceplate1645223faceplate
fermate122813003_fermate
ferrate103014043_ferrate
herbage1337003_herbage
iterate71119113iter_ate
lacerable1346943lacerable
lacerated122210673lacer_ated
lacerates112413773lacer_ates
macerated142010523macer_ated
macerater13259523macer_ater
macerates132113573macer_ates
makebate1645063make_bate
nervate1039533_nervate
ocellate1037873ocellate
ocreate93711743oc_reate
operate9615733oper_ate
overate10620963over_ate
overbake17129803overbake
overbite13312083overbite
overhate14312793overhate
overlate11716283overlate
overrate11615693overrate
racemate1239063race_mate
rebate84424113_re_bate
recrate92621663recr_ate
recreate10313603recreate
seriate73722473_seriate
serrate73017543_serrate
sorbate9311733_sorbate
ternate7415483_ternate
ulcerate1039733ulcer_ate
valerate11311473valer_ate

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.403443402.0
2DLD Change Limit1461621187.03320782.3
3Display Results1181180.0462565.2
 (SQL Overall)1786911187.48223882.8
 
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.