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

135 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
upleaped133433(None) 
upheaped1633641upheaped
beleaped1336102beleaped
leaped94317772__leaped
outleaped1246172outleaped
pleaded113511262_pleaded
pleased103712072_pleased
pleated103816632_pleated
unleaded10411332unleaded
unleased9310712unleased
unpleased1236082unpleased
upheaved1733762upheaved
upleap10106842upleap__
upleaps1185232upleap_s
upleapt11116862upleap_t
uploaded1234532uploaded
upreared1137072upreared
appealed1335603appealed
appeared1336143appeared
appeased1335793appeased
bleared104211253_bleared
bleated104015973_bleated
bleeped12287273_bleeped
cleaned103512003_cleaned
cleared103612463_cleared
cleated103417843_cleated
cleaved134010483_cleaved
cleped115114113_cle_ped
deleaded1148333deleaded
deleaved1346573deleaved
duplexed1943143duple_xed
galeated104111573galeated
gleamed11327933_gleamed
gleaned9349423_gleaned
heaped124516903__heaped
impleaded1543933impleaded
leaded84221543__leaded
leafed105713873__leafed
leaked114217703__leaked
leaned73422543__leaned
leaper88118943__leaper
leased74722883__leased
leaved105719023__leaved
nucleated1247873nucleated
peaced115818913_p_eaced
peaked136117403_p_eaked
pealed95322813_p_ealed
peeped113915393_p_eeped
pepped103113403_p_epped
pileated112711133pileated
placed114318003_pl_aced
planed94420913_pl_aned
plated95225773_pl_ated
played124815033_pl_ayed
pleached16338063_pleached
plead85818463_plea__d
pleader103511753_pleader
please84315733_please_
pleaser93912343_pleaser
pleases94515483_pleases
pleater93916333_pleater
pledged12358633_pledged
pleopod1244823_pleopod
plopped11288773_plopped
plumped14318643_plumped
poleaxed1854823poleaxed
preaged11612333_preaged
prepped11329903_prepped
pretaped13339133_pretaped
pulped114612533pul__ped
pulsated1136853pulsated
reaped94122453__reaped
released9310243released
repleaded1336293repleaded
shlepped1633643shlepped
sleaved113611133_sleaved
sneaped10338813_sneaped
speaned103411523sp_eaned
speared104314423sp_eared
splayed13357813spl_ayed
subleased1246123subleased
threaped1454863threaped
ullaged937033u_llaged
unbeared111611653unbeared
uncleaned1237173uncleaned
uncleared1237543uncleared
undraped1239393undraped
unfeared121511013unfeared
unhealed121511073unhealed
unheated121514553unheated
unhelped1435923unhelped
unlaced102913733unl_aced
unladed92614373unl_aded
unlead73312373unlea__d
unleadeds1143943unleadeds
unlearned1035653unlearned
unleashed1345403unleashed
unletted9310313unletted
unlevied1236843unlevied
unloaded1049533unloaded
unplaced1338613unpl_aced
unplayed1437263unpl_ayed
unpledged1443843unpledged
unsealed91513623unsealed
unseamed111210663unseamed
unseared91113943unseared
unseated91317683unseated
unshaped14148443unshaped
unweaned1238593unweaned
unyeaned1237743unyeaned
upbearer1243583upbearer
updated11369423up_dated
upended11267323up_ended
upgazed2033423up_gazed
upgraded13215683upgraded
upheap13105213upheap__
upheaps1494233upheap_s
upheave1544023upheave_
upheaver1643443upheaver
upheaves1643913upheaves
upland938863upl_a_nd
upleaping1434363upleaping
uplifted1454423uplifted
uplinked15254203uplinked
upload9257783uploa__d
upped103715163up___ped
uprated103213323up_rated
upreached1764083upreached
upscaled13144873upscaled
upsoared11154353upsoared
upstaged12135243upstaged
upstared11156573upstared
upstepped1341943upstepped
upwelled1434663upwelled
ycleped1543393ycle_ped

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.420425454.8
2DLD Change Limit1461621357.37619815.9
3Display Results1351350.0462934.8
 (SQL Overall)1786911357.84222786.4
 
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.