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

269 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
sheather145821(None) 
heather133914851_heather
sheathe1348981sheathe_
sheathed1547211sheathed
sheathers1557541sheathers
sheathes14610181sheathes
aweather1434262aweather
breather133610592breather
cheater124816952cheat_er
feather133613502_feather
heater94828302_heat_er
heathen133410892_heathen
heathers143914732_heathers
heathery17349082_heathery
heathier1438342_heathier
leather103815782_leather
pleather1356652pleather
seater64534152s_eat_er
shatter103615692sh_atter
shearer104414682shea_rer
sheath12412882sheath__
sheaths1358742sheath_s
sheeter103814902sheet_er
shelter103214952shelt_er
slather103816062s_lather
swather134213592s_wather
sweater103712722sweat_er
sweatier1147032sweatier
theater104014252theat_er
weather133513222_weather
whether16346622whe_ther
wreather14268602wreather
aether94213673_ae_ther
bather115322513__bather
beater84729393_beat_er
blather125314203_blather
bleacher15358883bleacher
bleater94515303bleat_er
blether12459913ble_ther
breacher153011503breacher
breathe123711843breathe_
breathed14469643breathed
breathers14319093breathers
breathes134212903breathes
breathier1435383breathier
chatter124416643ch_atter
cheaper144010583chea_per
cheated134416343cheat_ed
cheaters133613503cheat_ers
chertier1387873chertier
chestier1387423chestier
diether1147443die_ther
eater54639843__eat_er
either94517423__either
ensheathe15143633ensheathe_
ensheathed17162983ensheathed
ensheathes16133373ensheathes
ether84518773__e_ther
father125116713__father
feater95224053_feat_er
feathers143513243_feathers
feathery17368073_feathery
gather104115853__gather
greater84416493great_er
hatcher153314723_h_atcher
hater85034753_h_at_er
hatter94724873_h_atter
header104422543_hea_der
headier113212953_headier
healer94221803_hea_ler
healthier1544253_healthier
heaper114119523_hea_per
hearer94323643_hea_rer
heartier1139093_heartier
heated104525593_heat_ed
heaters104225213_heat_ers
heath115724283_heath__
heathenry1843403_heathenry
heathens143210153_heathens
heathered16149463_heathered
heaths126316383_heath_s
heathy156111213_heath_y
heaver124819673_hea_ver
heavier13429423_heavier
hefter124313923_heft_er
heftier1337203_heftier
hither124417253_h_ither
ingather1244773ingather
insheathe15163883insheathe_
insheathed17173073insheathed
insheathes16143573insheathes
lather95124353__lather
leacher124014843_leacher
leathern11398913_leathern
leathers114215083_leathers
leathery14438973_leathery
loather103711003_loather
meatier93214613_meatier
neater64424313_neat_er
neatherd12107193_neatherd
neither1037573_neither
nether94014163_ne_ther
peacher144216073_peacher
peatier94017233_peatier
phatter123810203ph_atter
pleater93916333pleat_er
pleathers1446453pleathers
preacher153211373preacher
rather94319733__rather
reacher123718293_reacher
regather1236733regather
reheater113413033reheat_er
scathe114414993s_cathe_
scathed134012643s_cathed
scathes124515713s_cathes
scatter93815173s_catter
scepter1138353scept_er
scouther1356943scouther
scratcher1635433scratcher
sealer63928963s_ea_ler
seamer84223613s_ea_mer
seamier93114633s_eamier
searcher13209103s_earcher
searer65432023s_ea_rer
seated75131053s_eat_ed
seaters74028933s_eat_ers
sedater83713623sedat_er
seethe93712483s_eethe_
seethed113410193s_eethed
seethes103613743s_eethes
seltzer1635203s_eltzer
setter64023723s_e_tter
settler73410653s_ettler
shader104218763sh_a_der
shadier113111153sh_adier
shaker134319463sh_a_ker
shakier143411153sh_akier
shalier103116423sh_alier
shammer144613143sh_ammer
shaper114119933sh_a_per
sharer95025483sh_a_rer
sharker144313813sh_arker
sharper124312703sh_arper
shatters113313903sh_atters
shaver123718913sh_a_ver
sheafed14388973shea_fed
shear85424833shea___r
sheared114516003shea_red
shearers113911323shea_rers
sheathing1636863sheathing
sheave124514003shea_ve_
sheaved143411633shea_ved
sheaves134412973shea_ves
shedder12339323she_dder
sheenier11167423sheenier
sheer84726893she___er
sheerer103813843she_erer
sheeted113813033sheet_ed
sheeters113111853sheet_ers
sheetfed1544133sheetfed
sheller103515883she_ller
shellier1138393shellier
shelterer1245033shelterer
shelters113412803shelt_ers
sheltie10109893sheltie_
shelties111111373shelties
shelver134211063she_lver
shelvier1464913shelvier
shepherd1744373she_pherd
shewer124515103she__wer
shifter132911073shift_er
shiftier1436333shiftier
shirtier1137933shirtier
shittier1137303shittier
shoaler102610073shoa_ler
shoalier1137063shoalier
shooter103013973shoot_er
shorter103515493short_er
shouter103213073shout_er
shunter103611723shunt_er
shusher13288113sh_usher
shutter103712133sh_utter
shuttler1164893shuttler
shyster13116553shyst_er
skater105015483s_kat_er
skeeter113410413skeet_er
skelter113610003skelt_er
sketcher1735433sketcher
slasher104515323s_lasher
slater64429183s_lat_er
slathers113914773s_lathers
slatier74016813s_latier
sleazier1735123sleazier
sleetier837883sleetier
sleigher1234313sleigher
sleuthed1233813sleuthed
slither104112983s_lither
smasher123911013s_masher
smatter93613333s_matter
smearer94110403smea_rer
smearier1036953smearier
smelter93311913smelt_er
smoother13196663smoother
smother123510203s_mother
snatcher13167753s_natcher
snathe94415113s_nathe_
snathes104816493s_nathes
sneaker112910453snea_ker
sneakier1245143sneakier
soother104215033s_oother
souther104116303s_outher
spathe115115693s_pathe_
spathed134013183s_pathed
spathes125116533s_pathes
spatter94016523s_patter
speaker133311213spea_ker
spearer93913663spea_rer
specter113111733spect_er
spelter94113703spelt_er
splasher1335653splasher
splatter10348883splatter
squasher20185773squasher
squatter1735913squatter
stater64427553s_tat_er
steadier937313steadier
stealer72913973stea_ler
stealthier1342863stealthier
steamer93313093stea_mer
steamier1048303steamier
stepfather1862063stepfather
sunbather1443023sunbather
svelter10359673svelt_er
swasher134011503s_washer
swathe125514113s_wathe_
swathed144611933s_wathed
swathers144512073s_wathers
swathes134115513s_wathes
swatter104113323s_watter
swearer10349953swea_rer
sweated113411543sweat_ed
sweaters113811053sweat_ers
sweeter103212003sweet_er
swelter103711173swelt_er
swither133710993s_wither
teacher123714833_teacher
teether10349693_teether
tether93716103_te_ther
thatcher1635653th_atcher
theaters114211893theat_ers
theatre10358493theatre_
theatres11298633theatres
thither13328103th_ither
thrasher1455733thrasher
treater74219833treat_er
unsheathe15174753unsheathe_
unsheathed17174133unsheathed
unsheathes16183843unsheathes
upgather14152753upgather
weathers143412833_weathers
wether123315393_we_ther
wheatear1442563wheatear
wheaten1336403wheat_en
whetter13348803whe_tter
whither163510253wh_ither
wreathe13339053wreathe_
wreathed15257463wreathed
wreathen14256143wreathen
wreathers15257483wreathers
wreathes14299893wreathes

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 Filter1786911461620.1561145455.1
2DLD Change Limit1461622696.43622710.1
3Display Results2692690.1102445.5
 (SQL Overall)1786912696.70226662.3
 
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.