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

143 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
aplenty123717(None) 
plenty11311411_plenty
splent84720192splent_
splents93912132splents
abhenry1543333abhenry
ablest84721833ablest_
abluent939623abluent_
abluents1045463abluents
absent84016993absent_
absently1345813absently
absents93510723absents
accent105116263accent_
accents113511233accents
advent102613753advent_
advents11309473advents
agency1237033a_gency
agent65829643a_gent_
agentry11165753a_gentry
agents74816293a_gents
aglet65534143agle_t_
aglets73915683agle_ts
agley96917333agle__y
ailment9314233ailment_
ailments1039433ailments
alant55742293a_lant_
alants67722023a_lants
alert54740653a_lert_
alertly1046793a_lertly
alerts64418223a_lerts
alienly1037503alienly
allergy1144503allergy
alley85721673alle__y
amenity1238333a_menity
ament76036543a_ment_
aments85219803a_ments
amnesty1244823amnesty
amplest11312333amplest_
anent54931843a_nent_
apery106517903ap_e_ry
aplite8316393apl_ite
append1138273appen_d
appends1236393appends
applet105917433apple_t_
applets115710063apple_ts
aptest82917513aptest_
ardency1346483ardency
ardent73022613ardent_
ardently1247453ardently
argent74023663argent_
argents84014853argents
arpent84822093arpent_
arpents93613083arpents
ascent84519653ascent_
ascents93812553ascents
aslant6317753aslant_
assent65119953assent_
assents74512223assents
attent62818323attent_
aunty85919813a__unty
blenny1156203_blenny
blent76230953_blent_
caplet104226813caple_t_
caplets114914523caple_ts
flinty126112493_flinty
gleety10479193_gleety
glinty106910693_glinty
haplont12412563haplont_
haplonts1345773haplonts
lefty115613563__lefty
lenity9612713__lenity
lent46360533__lent_
lento57223393__lento
linty87126563__linty
openly1137123op_enly
opulency1543323opulency
opulent938833opulent_
opulently1443633opulently
painty114714753_painty
paleate94120003paleate
palely11311933pale_ly
palest83926223palest_
palet74650803pale_t_
palets85122313pale_ts
palette93613983palette
panty105929303_p_anty
parent83230423parent_
parents93418123parents
patency1466313patency
patent84524923patent_
patently1347113patently
patents94815203patents
peaty105725693_p_eaty
penny105119453_p_enny
pent66559073_p_ent_
pentyl1138813_p_entyl
pesty106421713_p_esty
petty105320293_p_etty
piety105817303_pie_ty
plant75437113_plant_
plants84921803_plants
platy105021663_pl_aty
pleat74734473_pleat_
pleats85218593_pleats
plena75816393_plen_a
plenary1237543_plenary
plench134010813_plench
plenum1039503_plenum
plinth11310453_plinth
plotty11208853_plotty
plunky15377953_plunky
pointy114913283_pointy
polenta9310093polenta
pretty11510873_pretty
punty106021613_p_unty
relent64431853relent_
relents74018503relents
sapiency15114493sapiency
sapient9415333sapient_
sapiently1444863sapiently
sapients1037423sapients
seventy1338033seventy
silent64125843silent_
silently1147483silently
silents73514493silents
sklent103614353sklent_
sklents11348163sklents
slanty95114843_slanty
sleety94112653_sleety
spendy124911143sp_endy
spent75532833sp_ent_
spleeny1234563spleeny
splenia948313splenia
splenic1148663splenic
splenii945543splenii
splint85223283splint_
splints94511743splints
sprent84522383sprent_
talent6323323talent_
talents7312013talents
tenty86121603__tenty
twenty1236223_twenty
upsent83314063upsent_
valency1565463valency

Search took 7 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 Filter1786911340270.423422437.4
2DLD Change Limit1340271436.45320769.7
3Display Results1431430.0463108.7
 (SQL Overall)1786911436.92225814.9
 
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.