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

104 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
yearends1223448(None) 
yearend11285701yearend_
headends13326722headends
yearned11327372yearned_
yearners11346372yearners
yearns9509542year_n_s
amends94713283__amends
arenas65021993__arenas
arenes64928393__arenes
bartends1136793_bartends
beards94116673bear__ds
bearers94619593beare_rs
bearings113912253bearings
befriends1542413befriends
calends1039523_calends
deadens93410693deaden_s
deafens11317253deafen_s
dearness939973dearness
defends12358773de_fends
depends11348993de_pends
descends12266983descends
earbuds1044633_earbuds
eared65139503_eare_d_
earings84517713_earings
earned74818333_earned_
earners74016453_earners
earns55927563_ear_n_s
emends95711433_e_mends
errands847603_errands
expends17217083_expends
extends15227113_extends
feared106320433feare_d_
fearers104815273feare_rs
geared85317743geare_d_
gearheads1444083gearheads
gearings10359503gearings
gerents82612923ge_rents
gerunds935183ge_runds
headend12398363headend_
hearers104319783heare_rs
hearings123611853hearings
hearkens15336693hearken_s
heartens113010153hearten_s
heavens13439303heaven_s
jereeds15326393je_reeds
jerreeds1653273jerreeds
kalends1235683_kalends
lagends947273_lagends
leadens83610983leaden_s
learned8329303learned_
learners8398153learners
learns65513743lear_n_s
leavens10409303leaven_s
legends936073le_gends
neared75119803neare_d_
nearness838313nearness
neatens73310403neaten_s
nereids838743ne_reids
parents93418123_parents
peahens12307573peahen_s
perpends13227753perpends
reagents959623reagents
reared75930013reare_d_
rearers74323563reare_rs
reascends1244293reascends
reblends1135293reblends
rebreeds11426003rebreeds
regrinds1035533regrinds
relends84013253re_lends
remends105013033re_mends
rends65129953___rends
rereads81512293re_reads
rerents73319423re_rents
resends83513713re_sends
retreads937823retreads
reverends13266033reverends
seabeds10417223seabe_ds
seared75232843seare_d_
seaweeds12104453seaweeds
serenes73222903se_renes
teared75722153teare_d_
tearers75218233teare_rs
terrenes82212603terrenes
trends75513543__trends
uptrends1142833uptrends
weakens14367063weaken_s
wearers104615903weare_rs
weasands1244563weasands
weazands2143333weazands
weekends1642733weekends
yamens114010823y_amen_s
yards95324613y_ar__ds
yarned105514023y_arned_
yarners104312203y_arners
yarns85621793y_ar_n_s
yealings12257703yealings
yeaned103813903yeane_d_
yeans86624883yea__n_s
yearlies1137603yearlies
yearlings1384203yearlings
yearn86316433year_n__
yearner10336873year_ner
yearnings1393553yearnings
years84527673year___s

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 Limit1461621047.22020244.0
3Display Results1041040.0303466.7
 (SQL Overall)1786911047.67023297.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.