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

260 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
yearend1128570(None) 
yearends12234481yearends
yearned11327371yearned
eared65139502_eare_d
earned74818332_earned
feared106320432feare_d
geared85317742geare_d
headend12398362headend
learned8329302learned
neared75119802neare_d
reared75930012reare_d
seared75232842seare_d
teared75722152teare_d
yarned105514022y_arned
yeaned103813902yeane_d
yearn86316432year_n_
yearner10336872yearner
yearns9509542year_ns
afeared1176833afeare_d
amend85717753__amend
aneared8512743aneare_d
arena55323813__arena
arene55329413__arene
bared85144483_bare_d
barned95623583_barned
bartend1038753_bartend
beaded104922423beade_d
beaked135919493beake_d
beamed115720733beame_d
beaned95621473beane_d
beard86024963bear__d
bearded114212133bearded
bearer85323913beare_r
bearers94619593bearers
bearing103624773bearing
beaten84617063beaten_
befriend1443263befriend
bewared13310113beware_d
blared95018243blare_d
bleared104211253bleare_d
cared86050093_care_d
ceased94920783cease_d
cered85227443ce_re_d
chared125423693chare_d
cleared103612463cleare_d
dared75935013_dare_d
darned85018483_darned
deaden83714323deaden_
deadened1137233deadened
deadens93410693deadens
deafen10389673deafen_
deafened1335853deafened
deafens11317253deafens
deaired9411533deaire_d
deaned84620453deane_d
dearer74822803deare_r
dearest83618673dearest
deaved114916553deave_d
decreed112710253decreed
defend113910493de_fend
degreed10258883degreed
depend103510923de_pend
descend11248153descend
earbud936283_earbud
earing75235483_earing
earn46737553_ear_n_
earner63617223_earner
earns55927563_ear_ns
eased65430403_ease_d
eaten55323053_eaten_
eaved95924503_eave_d
emend86214893_e_mend
errand758793_errand
erred65915673_erre_d
expend16247503_expend
extend14267523_extend
fared95842343_fare_d
fearer94820183feare_r
fearers104815273fearers
fearing113520033fearing
feased105718713fease_d
feazed195112633feaze_d
flared105317603flare_d
gearhead1344433gearhead
gearing92818843gearing
gerent73223093ge_rent
gerund836163ge_rund
glared84715193glare_d
hared95742183_hare_d
headed114020473heade_d
headends13326723headends
healed105121443heale_d
heaped124516903heape_d
heard95222753hear__d
hearer94323643heare_r
hearers104319783hearers
hearing113324163hearing
hearken14338023hearken_
hearkened1744453hearkened
hearkens15336693hearkens
hearsed113811403hearsed
hearted113314023hearted
hearten102411753hearten_
heartened1347063heartened
heartens113010153heartens
heated104525593heate_d
heaved134717863heave_d
heaven123912603heaven_
heavens13439303heavens
heired103813043heire_d
jeaned143813463jeane_d
jeered143912793jeere_d
jereed144012073je_reed
jerreed1535213jerreed
kerned114112933ke_rned
lagend838743_lagend
leaded84221543leade_d
leaden74515223leaden_
leadened1036153leadened
leadens83610983leadens
leafed105713873leafe_d
leaked114217703leake_d
leaned73422543leane_d
leaped94317773leape_d
learn55322663lear_n_
learner7319383learner
learns65513743lear_ns
learnt64019253lear_nt
leased74722883lease_d
leaved105719023leave_d
leaven95013073leaven_
leavened1235553leavened
leavens10409303leavens
leered73816223leere_d
legend837693le_gend
meated94222403meate_d
metred95315143metre_d
nearer64618893neare_r
nearest73415843nearest
nearing83020333nearing
neaten64214543neaten_
neatened937043neatened
neatens73310403neatens
nereid7312923ne_reid
oared65030653_oare_d
pared86946763_pare_d
parent83230423_parent
peaced115818913peace_d
peahen113410133peahen_
peahens12307573peahens
peaked136117403peake_d
pealed95322813peale_d
pearled10411553pearled
peasen84815963peasen_
peered93819493peere_d
perpend12259353perpend
rared65738323_rare_d
reagent8716603reagent
reamed94326123reame_d
reaped94122453reape_d
rearer64928913reare_r
rearers74323563rearers
rearing83128783rearing
rearmed103912823rearmed
reascend1145703reascend
reaved104523923reave_d
reblend1036653reblend
rebred95816353rebre_d
rebreed104611073rebreed
reearned948883reearned
regrind938983regrind
relend76116453re_lend
remend95216553re_mend
rend56136573___rend
reread71715433re_read
rerent63832453re_rent
resend75016773re_send
retread849003retread
reverend12288853reverend
roared75015393roare_d
scared95227293scare_d
seabed95017693seabe_d
sealed74328363seale_d
seamed94823883seame_d
seamen84518563seamen_
searer65432023seare_r
searest73322023searest
searing83330923searing
seated75131063seate_d
seaweed11108813seaweed
sered65737293se_re_d
serene63522353se_rene
shared105829063share_d
sheared114516003sheare_d
smeared104510623smeare_d
snared74824553snare_d
soared74324293soare_d
spared95427493spare_d
speared104314423speare_d
stared75429873stare_d
tared69340053_tare_d
teamed95418593teame_d
tearer64822903teare_r
tearers75218233tearers
tearing84021493tearing
teased74721153tease_d
teated74924023teate_d
terrene72411033terrene
trend64817453__trend
unearned9310063unearned
uptrend1044293uptrend
vealed103916323veale_d
veered103612743veere_d
wared96339873_ware_d
warned104018913_warned
weaken13349603weaken_
weakened1634823weakened
weakens14367063weakens
weaned103816153weane_d
wearer94319403weare_r
wearers104615903wearers
wearied112911803wearied
wearing113318863wearing
weasand1135503weasand
weaved133913483weave_d
weazand2043613weazand
weekend1533393weekend
yamen104115183y_amen_
yamens114010823y_amens
yard85633253y_ar__d
yarded114714023y_arded
yare75636943y_are__
yarely122810303y_arely
yarer84321573y_are_r
yarest95018913y_arest
yarn75230043y_ar_n_
yarner93313063y_arner
yarns85621793y_ar_ns
yawed126022453y_awe_d
yawned13509843y_awned
yealing112716383yealing
yean75834583yea__n_
yeaning113814633yeaning
yeans86624883yea__ns
year76534253year___
yearling1297883yearling
yearlong12102573yearlong
yearly125210273year_ly
yearners11346373yearners
yearning1296983yearning
years84527673year__s
yeasted1138503yeasted
yelled104116253yelle_d
yelped12439363yelpe_d
yenned10409383yenne_d
yeomen1138183yeomen_
yerked14509373ye_rked
yessed104511163yesse_d
yeuked14456233yeuke_d
yirred10426963yirre_d

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 Filter1786911340270.406440125.6
2DLD Change Limit1340272606.72019944.5
3Display Results2602600.0932795.7
 (SQL Overall)1786912607.21924752.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.