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

137 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
oleanders103557(None) 
oleander936401oleander_
alexanders1842442alexanders
blenders115210992ble_nders
cleaners103610542clean_ers
cleansers11335072cleansers
colanders1238012col_anders
coleaders1237822colea_ders
glanders103811502gl_anders
gleaners9348072glean_ers
landers84026212_l_anders
leaders83819602_lea_ders
leaners73718172_lean_ers
lenders84419642_le_nders
meanders1168832_meanders
oleasters936732oleasters
pleaders113210182plea_ders
slanders94014012sl_anders
solanders1036962sol_anders
alexander1742773alexander_
amenders11288353ame_nders
banders104324563__banders
beaders104120183_bea_ders
benders104021063_be_nders
bilanders1235963bilanders
bladders12397803bl_adders
bladers104214683bl_a_ders
blander103715163bl_ander_
bleachers16297923bleachers
bleaters103412323blea_ters
bleeders11448453ble_eders
blender104613843ble_nder_
blendes104713683ble_nde_s
blinders113911143bl_inders
blunders113911343bl_unders
branders114313093_branders
calenders1237403cale_nders
clangers114312343cl_angers
cleaner93712303clean_er_
cleanness1144973cleanness
cleanser10356323cleanser_
cleanses10358143cleanse_s
clearers10349303clea_rers
cleavers13398873clea_vers
colander1139033col_ander_
coleader1139183colea_der_
commanders17146683commanders
corianders1344903corianders
danders93921183__danders
demanders13247573demanders
emenders11319033eme_nders
enders74324053__e_nders
expanders19125093expanders
fenders113717263_fe_nders
flangers123311373fl_angers
flankers15349303fl_ankers
flensers1135463fle_nsers
flinders12439263fl_inders
flounders1374613flounders
ganders93521703__ganders
genders93616783_ge_nders
glancers11408003gl_ancers
glandes95413833gl_ande_s
gleamers11306563glea_mers
gleaner8379773glean_er_
goosanders1242863goosanders
handers114224333__handers
headers113819393_hea_ders
inlanders1036143inlanders
islanders1035283islanders
kneaders1384713knea_ders
ladders94115173_l_adders
laders74927763_l_a_ders
lancers93616643_l_ancers
lander74028483_l_ander_
landlers94312833_l_andlers
lanners73618333_l_anners
larders83516943_l_arders
lauders84012893_l_auders
launders9358743_launders
leachers133712813_leachers
leadens83610983_lea_dens
leader74824653_lea_der_
leaguers935063_leaguers
leakers113415423_lea_kers
leaner64022193_lean_er_
leanness837373_leanness
leapers93716663_lea_pers
learners8398153_learners
leasers74717843_lea_sers
leathers114215083_leathers
leavers103717783_lea_vers
lender73921273_le_nder_
levanters1254993_levanters
loaders83413433_loa_ders
loaners73913623_loan_ers
lowlanders1442693lowlanders
malanders1237023malanders
meander1049973_meander_
meaners94415243_mean_ers
menders103818803_me_nders
offenders1643403offenders
oleaster837263oleaster_
oleates7417833olea_te_s
oleines7313393olein_e_s
openers9339493ope_n_ers
outlanders1144273outlanders
panders103423733__panders
planers94517943pl_an_ers
planners10399933pl_anners
planters102915323pl_anters
pleader103511753plea_der_
pleasers104010293plea_sers
pleaters103613793plea_ters
pleathers1446453pleathers
plunders11329833pl_unders
pomanders1436223pomanders
readers83823773_rea_ders
relaunders1153103relaunders
renders83821673_re_nders
sanders84025943__sanders
senders83022353_se_nders
slander84015443sl_ander_
sledders10257373sle_dders
slender83413593sle_nder_
solander948123sol_ander_
spenders113211743spe_nders
squanders1934443squanders
standers93514303_standers
stranders10389933stranders
tenders83719723_te_nders
treaders93311843trea_ders
uplanders1234853uplanders
venders113717003_ve_nders
wanders114221333__wanders
weaners104613833_wean_ers
zanders173015793__zanders

Search took 7 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 Filter1786911486410.423422437.4
2DLD Change Limit1486411376.28023668.9
3Display Results1371370.0462978.3
 (SQL Overall)1786911376.74926476.7
 
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.