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

212 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
upreared113707(None) 
appeared1336142appeared
preaged11612332_preaged
prearmed1397982_prearmed
prepared132210862_prepared
purebred1344252purebred
reared75930012__reared
speared104314422sp_eared
unbeared111611652unbeared
unfeared121511012unfeared
unprepared1543022unprepared
unseared91113942unseared
upbearer1243582upbearer
upheaped1633642upheaped
upheaved1733762upheaved
upleaped1334332upleaped
uprated103213322upr_ated
upreached1764082upreached
uprear8168792uprear__
uprears9107492uprear_s
upsoared11154352upsoared
upstared11156572upstared
afeared1176833_afeared
aneared8512743_aneared
appealed1335593appealed
appeased1335793appeased
bereaved1446403bereaved
bleared104211253_bleared
breaded115014063_breaded
breamed124011593_breamed
careered1139493careered
cleared103612463_cleared
creaked143413233_creaked
creamed123913713_creamed
creased104315583_creased
created104323443_created
cupbearer1542403cupbearer
dogeared1145793dogeared
dreaded103612023_dreaded
dreamed114310633_dreamed
eared65139503___eared
endeared1038053endeared
feared106320433__feared
firearmed1544043firearmed
forearmed1544863forearmed
freaked15399703_freaked
geared85317743__geared
greased93812393_greased
greaved12408913_greaved
mortared1137213mortared
neared75119803__neared
operated11512223operated
outroared10158113outroared
pared86946763_p__ared
peaced115818913_p_eaced
peaked136117403_p_eaked
pealed95322803_p_ealed
pearled10411533_p_earled
peered93819483_p_eered
phreaked1834493phreaked
pleaded113511263_pleaded
pleased103712073_pleased
pleated103816633_pleated
prated94924923_pr_ated
prayed124815433_pr_ayed
preached163412063_preached
preacted132710943_preacted
prearm104512343_prear_m
prearms11369173_prearms
preaver121011613_preaver
prebaked1737173_prebaked
precured1339993_precured
predated12513273_predated
predried12309573_predried
preed85128113_pre__ed
preened103214983_preened
prefaced1638423_prefaced
prefaded1537823_prefaded
prefired144310753_prefired
premed114617753_pre_med
prepare111913623_prepare_
preparer12169643_preparer
prepares122014163_prepares
prepaved16177223_prepaved
prepped11329893_prepped
prepreg12165963_prepreg
presaged1238803_presaged
pressed103317303_pressed
pretaped13339133_pretaped
prevued1337143_prevued
prewarmed17104563_prewarmed
prewarned1594773_prewarned
prewired14358473_prewired
preyed125313193_pre_yed
purebreds1442163purebreds
pureed95017803pure__ed
purred94218073pur__red
rared65738323__r_ared
reamed94326123__reamed
reaped94122453__reaped
rearer64928913__rearer
rearmed103912823__rearmed
reaved104523923__reaved
rebred95816353__rebred
regeared1039433regeared
roared75015393__roared
screaked15246973screaked
screamed13277593screamed
seared75232843__seared
sheared114516003_sheared
smeared104510623_smeared
spared95427483sp__ared
speaned103411523sp_eaned
spearer93913663sp_earer
speered103614813sp_eered
speired103811103sp_eired
sphered133512313sphe_red
spiered104412463spie_red
sprayed13398903spr_ayed
spread9312533sprea__d
spreader1137473spreader
streaked13228453streaked
streamed11258903streamed
supered10316123sup_e_red
teared75722153__teared
threaded1366323threaded
threaped1454863threaped
threated1259203threated
treaded95014283_treaded
treated83618703_treated
ulcered1037973ulce_red
ultrared936663ultrared
umbered121510113umbe_red
unbearded13146343unbearded
uncleared1237543uncleared
uncreated12312303uncreated
undreamed1336973undreamed
unearned9310063u_nearned
unerased9312773unerased
ungreased1136333ungreased
unhealed121511073unhealed
unheard1136943unhear_d
unheated121514553unheated
unleaded10411333unleaded
unlearned1035653unlearned
unleased9310713unleased
unpleased1236083unpleased
unpressed1237953unpressed
unraked122914013unr_aked
unrated82621553unr_ated
unrazed172511453unr_azed
unreached1536883unreached
unread73412673unrea__d
unreeled91310333unreeled
unreeved12117673unreeved
unrelated10310433unrelated
unrelaxed1744453unrelaxed
unremarked1743203unremarked
unrented92413923unrented
unrested91914513unrested
unretired1046433unretired
unrewarded1542993unrewarded
unsealed91513623unsealed
unseamed111210663unseamed
unseated91317683unseated
unshared121510703unshared
untreaded1137983untreaded
untreated10312903untreated
unweaned1238593unweaned
unwearied1336763unwearied
unyeaned1237743unyeaned
upbear1096493upbear__
upbearers1343033upbearers
upbears1195423upbear_s
updarted1244313up_darted
updated11369423up_dated
upended11267323up_ended
upgazed2033423up_gazed
upgraded13215683upgraded
upheave1544023upheave_
upheaver1643443upheaver
upheaves1643913upheaves
uphoard1344573uphoar_d
uphoarded1662273uphoarded
uploaded1234533uploaded
upraised11167413upraised
uprate83916543upr_ate_
uprates93814863upr_ates
upreach1444693uprea_ch
upreaches1654633upreaches
uprearing1238373uprearing
uproar8106933uproar__
uproars986453uproar_s
uprooted1186393uprooted
uproused1135833uproused
uprushed14234473uprushed
upscaled13144873upscaled
upstaged12135243upstaged
upstare9158683upstare_
upstares10178583upstares
upstarted1244213upstarted
uptear896783uptear__
uptears9106443uptear_s
upward12147163up_war_d
upwelled1434663upwelled
urare56322553u_r_are_
urares64519093u_r_ares
urease64516993u_rease_
ureases74416723u_reases
ushered1139153ushe_red
uttered82712433utte_red
wreaked15369023_wreaked

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.203880251.2
2DLD Change Limit1461622128.37317456.3
3Display Results2122120.0932279.6
 (SQL Overall)1786912128.66920612.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.