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

102 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
upheaped163364(None) 
upheaved1733761upheaved
upleaped1334331upleaped
heaped124516902__heaped
unhealed121511072unhealed
unheated121514552unheated
unhelped1435922unhelped
upheap13105212upheap__
upheaps1494232upheap_s
upheave1544022upheave_
upheaver1643442upheaver
upheaves1643912upheaves
upreared1137072upreared
appealed1335603appealed
appeared1336143appeared
appeased1335793appeased
beheaded1536373beheaded
beleaped1336103beleaped
cheapen14407623_cheapen
cheaper144010583_cheaper
cheated134416343_cheated
cheeped153410593_cheeped
coheaded1536603coheaded
headed114020473__headed
healed105121443__healed
heaper114119523__heaper
heated104525593__heated
heaved134717863__heaved
helped124714153__helped
leaped94317773__leaped
outleaped1246173outleaped
peaced115818913_p_eaced
peaked136117403_p_eaked
pealed95322813_p_ealed
peeped113915393_p_eeped
pepped103113403_p_epped
phased124011973_ph_ased
phrased1387383_phrased
phreaked1834493_phreaked
pleaded113511263_pleaded
pleased103712073_pleased
pleated103816633_pleated
preaged11612333_preaged
prepped11329903_prepped
pretaped13339133_pretaped
reaped94122453__reaped
reheated122415003reheated
sapheaded1644183sapheaded
shaped125020103_sh_aped
sheafed14388973_sheafed
sheared114516003_sheared
sheaved143411633_sheaved
sneaped10338813_sneaped
speaned103411523sp_eaned
speared104314423sp_eared
sphered133512313sphe_red
threaped1454863threaped
unbeared111611653unbeared
undraped1239393undraped
unfeared121511013unfeared
unheard1136943unhea_rd
unhedged1434973unhedged
unheeded1336893unheeded
unhelmed1435993unhelmed
unhoped13249353unh_oped
unleaded10411333unleaded
unleased9310713unleased
unpleased1236083unpleased
unsealed91513623unsealed
unseamed111210663unseamed
unseared91113943unseared
unseated91317683unseated
unshaped14148443unshaped
unweaned1238593unweaned
unyeaned1237743unyeaned
upbearer1243583upbearer
updated11369423up_dated
upended11267323up_ended
upgazed2033423up_gazed
upgraded13215683upgraded
upheaping1743853upheaping
upheaval1641583upheaval
upheavers1742593upheavers
upheld12115563uphe__ld
uphoard1344573uphoa_rd
uphoarded1662273uphoarded
upleap10106843upleap__
upleaps1185233upleap_s
upleapt11116863upleap_t
uploaded1234533uploaded
upped103715163up___ped
uprated103213323up_rated
upreached1764083upreached
upscaled13144873upscaled
upsoared11154353upsoared
upstaged12135243upstaged
upstared11156573upstared
upstepped1341943upstepped
upwelled1434663upwelled
ushered1139153ushe_red
wheeped16387503_wheeped
whelped16355633_whelped

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.436409841.7
2DLD Change Limit1461621027.65619091.2
3Display Results1021020.0462217.4
 (SQL Overall)1786911028.13821957.6
 
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.