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

232 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
oleaster83726(None) 
oleasters936731oleasters
blaster94017302bl_aster
bleater94515302blea_ter
easter65027982__easter
feaster10812982_feaster
laster64830632_l_aster
leaser65322672_leas_er
leister73212752_leister
molester1099372mole_ster
oldster896572ol_dster
oleander936402oleander
oleate6318882olea_te_
oleates7417832olea_tes
plaster93318692pl_aster
pleaser93912342pleas_er
pleater93916332plea_ter
alabaster1143353alabaster
alastor739673al_astor
alerter72111513ale_rter
aster55434893___aster
ballaster1145973ballaster
baster85333603__baster
beater84729393_bea_ter
blasted104213473bl_asted
blasters104116143bl_asters
blastier10249493bl_astier
blatter94415653bl_atter
bleacher15358883bleacher
bleaker133510533blea_ker
blearier1037333blearier
bleated104015973blea_ted
bleaters103412323blea_ters
blesser9329293ble_sser
blister94415313bl_ister
bloater94013423bloa_ter
bluster94215313bl_uster
boaster94616433_boaster
bolster93713423bol__ster
bombaster1543803bombaster
breasted1138823breasted
cadaster1136903cadaster
caster85232573__caster
chaster124718503_chaster
cheater124816963chea_ter
clasher124615513cl_asher
clasper113811863cl_asper
classer93614613cl_asser
clatter94014973cl_atter
cleaner93712303clea_ner
cleanser10356323cleanser
clearer93710823clea_rer
cleated103417853clea_ted
cleaver124110803clea_ver
cloister1037093cloister
cluster94013333cl_uster
clyster12317453cl_yster
coaster94219043_coaster
coleader1139183colea_der
creaser94415743creas_er
creasier103210203creasier
cytaster1383863cytaster
deemster1175713deemster
deluster936903deluster
diaster82813313_diaster
diester83013683die_ster
disaster949943disaster
dopester1137253dope_ster
easier64218463__easier
eastern74412533__eastern
easters75125683__easters
eater54639843__ea_ter
elater64724203el_a_ter
ester54727713__e_ster
faster94625773__faster
feasted11310843_feasted
feasters11511563_feasters
feater95224053_fea_ter
fester94723513_fe_ster
flasher133914063fl_asher
flatter103815963fl_atter
fleeter103210363fle_eter
flenser1036783flens_er
flesher133610923fle_sher
floater104413353floa_ter
fluster103913063fl_uster
forecaster1586013forecaster
forester11313673fore_ster
gaster75027353__gaster
gleamer10328513glea_mer
gleamier1144913gleamier
gleaner8379773glea_ner
glister84013343gl_ister
gloater83711013gloa_ter
greaser83913083greas_er
greasier9298083greasier
greater84416493grea_ter
heater94828303_hea_ter
heister103613623_heister
holster103512213hol__ster
honester1139713hone_ster
jester134319153_je_ster
jokester1934443joke_ster
keester11319913_keester
keister113011573_keister
keyster14256153_keyster
kiester11329973kie_ster
klister113410643kl_ister
lamster9109913_lamster
laser54633323_l_as_er
lasher94824533_l_asher
lasted74323603_l_asted
lasters75627693_l_asters
later54843923_l_a_ter
latter65027893_l_atter
leacher124014843_leacher
leader74824653_lea_der
leadier83212723_leadier
leafier10329833_leafier
leaguer835793_leaguer
leaker104620073_lea_ker
leakier114010993_leakier
leaner64022193_lea_ner
leaper88118943_lea_per
learier73415663_learier
learner7319383_learner
lease55230263_leas_e_
leased74722883_leas_ed
leasers74717843_leas_ers
leases65428113_leas_es
leashed113211163_leashed
leashes103514403_leashes
least56134883_least__
leasts64616413_least_s
leather103815783_leather
leaver94321513_lea_ver
leavier10319993_leavier
lefter93613433_le_fter
leisters83312823_leisters
lesser63514853_le_sser
letter63722583_le_tter
levanter1145303_levanter
lister64527253_l_ister
lobster9288853_lobster
locater93113603loca_ter
luster64023673_l_uster
master84831343__master
meister93114163_meister
modester1197483mode_ster
molested11178243mole_sted
molesters1198873mole_sters
muenster1043313muenster
neater64424313_nea_ter
nester64124183_ne_ster
oater55433733o__a_ter
oersted839563o_ersted
oldsters996733ol_dsters
oleanders1035573oleanders
olestra746173ole_stra
ouster64223733o__uster
outmaster1147303outmaster
overmaster1546023overmaster
overseer112611073overseer
oversteer1246413oversteer
overstep1338033overstep
overstir1137483overstir
oyster94111703o__yster
paster85734373__paster
pearter9412743_pearter
penster92811953_penster
pester84827593_pe_ster
piaster93012883_piaster
pilaster1038163pilaster
pinaster1037113pinaster
plaister1068013plaister
plaiter93615393pl_aiter
planter94017813pl_anter
plasher124215033pl_asher
plasters103518133pl_asters
plastery13279703pl_astery
plater84427693pl_a_ter
platter93917413pl_atter
pleader103511763plea_der
pleasanter1242423pleasanter
please84315733pleas_e_
pleased103712073pleas_ed
pleasers104010293pleas_ers
pleases94515483pleas_es
pleasure1045543pleasure
pleated103816633plea_ted
pleaters103613793plea_ters
pleather1356653pleather
poetaster1145673poetaster
polestar1047113pole_star
pollster1037103pol_lster
polyester1445353polyester
prealter1048863prealter
prester93519623pre_ster
queasier1734473queasier
quester161410023que_ster
raster64731443__raster
realter73716313_realter
relater73723143rela_ter
releaser839503releas_er
remaster10311473remaster
rester63832433_re_ster
roaster74116663_roaster
seamster1037143_seamster
seater64534163_sea_ter
slasher104515333sl_asher
slater64429183sl_a_ter
sleazier1735123sleazier
sweater103712723swea_ter
taster64930573__taster
teamster1036293_teamster
teaser65421523_teas_er
telecaster1244213telecaster
tester64227153_te_ster
theater104014253thea_ter
toaster74414463_toaster
treater74219833trea_ter
ulster63712103ul__ster
uneasier836963uneasier
vaster94521023__vaster
waster95228943__waster
webster1236093_webster
wester94222893_we_ster
wrester102812413wre_ster
yeasted1138503_yeasted
yeastier1135393_yeastier
yester93417983_ye_ster
zester153617793_ze_ster

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.440406115.9
2DLD Change Limit1461622327.51619446.8
3Display Results2322320.0932494.6
 (SQL Overall)1786912328.04922200.4
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.