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

316 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
salterns838889(None) 
saltern74010651saltern_
salters73622251salter_s
alters64924222_alter_s
falters103916472falter_s
halteres113414592halteres
halters104619802halter_s
lanterns838302lanterns
palters94021682palter_s
pasterns104112622pasterns
patterns10439942patterns
psalters10227712psalter_s
salter64325082salter__
saltiers83411952saltier_s
saltires83112422saltires
saltpans1034812saltpans
saluters8319852saluter_s
salvers103916002salver_s
santeras8311052santeras
santeros8311192santeros
sateens73710752sa_teens
sauterne846252sauterne
sauternes947022sauternes
slaters73123722slater_s
slatterns935362slatterns
sterns64616752s__terns
subalterns1242212subalterns
afters94717073_after_s
alders74218423_alder_s
alerts64418223_al_erts
aliens65619213_alie_ns
altars64518153_altar_s
alter54828503_alter__
alterant8614963_alterant
alterants979093_alterants
altered83215733_altered
alterer72713993_alterer
alterers82512493_alterers
altering91917113_altering
althorns1146723_althorns
astern64815813_astern_
asters65631603_aster_s
attorns738433_attorns
bacterins13410643bacterins
baiters94619303baiter_s
baleens938473bal_eens
balers85626933bal_er_s
balkers134915723balker_s
ballers94421013baller_s
banters94623113banter_s
barters94223033barter_s
basters94930303baster_s
battens95313263batte_ns
batters94626013batter_s
belters93819413belter_s
bitterns10428943bitterns
bolters94017803bolter_s
calderas1147863calderas
calkers134414693calker_s
callers94221963caller_s
canteens1038573canteens
canters94827723canter_s
carters95327243carter_s
caserns94711213ca_serns
casters94729893caster_s
caterans10313203ca_terans
caters85336493ca_ter_s
caverns124510243ca_verns
cisterns10369563cisterns
citterns10318113citterns
colters93522433colter_s
daltons8310403dalt_ons
darters84017603darter_s
daters74827363da_ter_s
desalters1037673desalter_s
eastern74412533eastern_
easters75125683easter_s
eaters65535943ea_ter_s
elaterins9410033elaterins
elaters74420183elater_s
exalters1536653exalter_s
externs1438233_externs
fallers103917993faller_s
falter94519053falter__
faltered122810983faltered
falterer11239853falterer
falterers12238033falterers
faltering132211113faltering
fastens105511753faste_ns
fattens105111713fatte_ns
filters103816543filter_s
gaiters83516533gaiter_s
galeres83514323gal_eres
galleins9258693galleins
galleons9258423galleons
garters84218223garter_s
gasters85624283gaster_s
gaters74728633ga_ter_s
gitterns9326563gitterns
hafters134614333hafter_s
halberds1435173halberds
halberts1335963halberts
halers94926913hal_er_s
halter94420883halter__
haltere103614703halter_e
haltered123112553haltered
haltering132212003haltering
halvers133311423halver_s
haptens124511343hapte_ns
hastens106214813haste_ns
haters94930393ha_ter_s
hatters104221523hatter_s
interns73116763_interns
jilters144211953jilter_s
jolters143711993jolter_s
kelters113813753kelter_s
kilters113813593kilter_s
klaverns1532243klaverns
lantern7310013lantern_
lasters75627693laster_s
lateens74210553la_teens
latens64620213la_te_ns
lattens75014673latte_ns
lecterns1035943lecterns
malteds10377603malte_ds
martens93714953marte_ns
masters94628923master_s
maters85032383ma_ter_s
matters94421753matter_s
melters93918313melter_s
milters93619083milter_s
misalters1136903misalter_s
molters93816973molter_s
natters73718063natter_s
oaters65029783oa_ter_s
palmers113513623palmer_s
palter84423263palter__
paltered113012483paltered
palterer102411273palterer
palterers11249533palterers
paltering122612893paltering
pastern94415063pastern_
pasters94531733paster_s
patens84820863pa_te_ns
paters84935823pa_ter_s
pattens95414923patte_ns
pattern93712053pattern_
patters94825193patter_s
pelters93720313pelter_s
platens94213983plate_ns
platers93924083plater_s
posterns102713703posterns
psalter9247813psalter__
psalteria1144003psalteria
psalteries1276563psalteries
psaltery13224733psalter_y
quarterns18285143quarterns
rafters103715633rafter_s
ranters73323643ranter_s
rasters74629023raster_s
raters63936573ra_ter_s
ratteens8256053ratteens
rattens74213403ratte_ns
ratters74422473ratter_s
realters83614043realter_s
sabers85224733sa_ber_s
sackers133820223sacker_s
saddens9309603sadde_ns
saggers94017083sagger_s
sailers73822313sailer_s
sakers104125433sa_ker_s
saleps85014903sal_e_ps
sales56055593sal_e__s
salicins10310933salicins
salient7419763salie_nt
salients839563salients
sallets73719653salle_ts
salliers83613333sallier_s
salmons93713253sal_mons
salons63823683sal__ons
saloons74415303sal_oons
salpians1036763salpians
saltant7316773salt_ant
salted74121203salte__d
saltest71916513salte_st
saltier74318633saltier__
salties73725773salt_ies
saltine75018563salt_ine
saltines82917793saltines
salting84120793salt_ing
saltings92811253saltings
saltire73113033saltir_e
saltless8259343saltless
saltness82610243saltness
saltpan935303saltpan_
saltpetres1252463saltpetres
salts55431883salt___s
saltworks1645163saltworks
saltworts1244633saltworts
saluter73512453saluter__
salutes73716253salute__s
salver94617753salver__
salves94221763salve__s
salvors103910903salvor_s
sanders84025943sander_s
sangers84421943sanger_s
santera7311303santer_a
santeria8311643santeria
santerias9311833santerias
santero7311133santer_o
santirs7312963santir_s
santurs7310763santur_s
sapiens9310173sapie_ns
sappers113518893sapper_s
sarsens7311393sarse_ns
sartors7314953sartor_s
sataras7315053sa_taras
sateen63815013sa_teen_
sates54949323sa_te__s
satins64930483sa_t_ins
satires72617573sa_tires
satoris7317233sa_toris
satyrs937963sa_tyr_s
saucers93712133saucer_s
saugers83914053sauger_s
saunters82911743saunter_s
sauteing937913sauteing
sautes63924913saute__s
savers93825923sa_ver_s
sawers94620163sa_wer_s
sawyers13317533sawyer_s
saxhorns1843823saxhorns
sayers94221593sa_yer_s
scalers93817263scal_er_s
scalpers123710863scalper_s
scatters103612753scatter_s
scleras948223scl_eras
scoters93313793scoter_s
sealers74323553seal_er_s
seaters74028933seater_s
secerns987733s_ecerns
sellers73721303seller_s
seltzers1735063seltzer_s
setters73822063setter_s
shatters113313903shatter_s
shelters113412803shelter_s
sifters103714783sifter_s
sillers73822093siller_s
silvern10347133silvern_
silvers104714033silver_s
sinters74024073sinter_s
sisters73721573sister_s
sitters74221543sitter_s
sixteens1542943sixteens
skaters113512943skater_s
skelters12349373skelter_s
slakers114115753slaker_s
slater64429183slater__
slates64934063slate__s
slathers113914773slather_s
slattern837093slattern_
slavers103716503slaver_s
slayers104513323slayer_s
smartens10286663smarte_ns
smatters104011713smatter_s
smelters103310513smelter_s
smiters93414363smiter_s
softens10347623softe_ns
solders83517773solder_s
solvers104414253solver_s
sorters74221113sorter_s
souters74422583souter_s
southerns12347213southerns
spaldeens1241793spaldeens
spallers102910723spaller_s
spalpeens1341843spalpeens
spatters103914703spatter_s
spelters103912243spelter_s
spleens937103spl_eens
stalkers12369843stalker_s
starters83714763starter_s
staters73922323stater_s
steins64818343s__teins
steres63929533s__teres
stern55319123s__tern_
sterna63712763s__terna
subaltern1143243subaltern_
subteens1037423subteens
suiters73618873suiter_s
sulkers113613343sulker_s
sultans72411833sult_ans
sutlers73116973sutler_s
swatters113911793swatter_s
swelters113110193swelter_s
talers64628143tal_er_s
talkers113513213talker_s
tasters74225643taster_s
taters64932193ta_ter_s
tatters74520483tatter_s
tautens7317843taute_ns
taverns10317803ta_verns
terns55226873___terns
tilters73315933tilter_s
valuers10328943valuer_s
vaulters11206163vaulter_s
wafters134112813wafter_s
waiters104218623waiter_s
walers94824463wal_er_s
walkers143411473walker_s
waltzers2034003waltzer_s
wanters104420093wanter_s
wasters104026593waster_s
waters95030623wa_ter_s
welters103516063welter_s
westerns11328963westerns
yatters103914623yatter_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.186960704.3
2DLD Change Limit1461623167.31319986.6
3Display Results3163160.1232569.1
 (SQL Overall)1786913167.62223444.1
 
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.