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 “shetlands” with Change Limit: [1] [2] [3] [4]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

319 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
shetlands134374(None) 
shetland1244631shetland_
wetlands1244762_wetlands
wheatlands1751992wheatlands
elands74914773__e_lands
fenlands1245183_fenlands
flatlands1364303flatlands
hatbands1446293_hatbands
headlands1444903_headlands
heartlands1462953_heartlands
heathlands1743403_heathlands
hetmans12187593_hetman_s
hollands12247273_hollands
outlands988563_outlands
overlands13218883overlands
relands85214883_re_lands
scablands1443783scablands
sealants82610743s_ealants
setlines8312743s_etlines
shealings13317563shealings
shebangs1443593she_bangs
shebeans1344703shebean_s
sheilas1059403sheila__s
sheitans1155603sheitan_s
shellacks1844553shellacks
shellacs1345573shella_cs
sheltas10279673shelta__s
shends105313773she___nds
shitloads1393503shitloads
shorthands1743493shorthands
shrublands1651623shrublands
snowlands1343573snowlands
solands84412343s__olands
southlands1463353southlands
stands75118053s__t_ands
strands83711953s__trands
sunlands936383s_unlands
sweatbands1651933sweatbands
wetland1135353_wetland_
wheatland1641953wheatland_
alands75418374___alands
ashplants1443534ash_plants
backlands1846824backlands
badlands1236674_badlands
beglads11127264_begla_ds
belauds1036644_be_lauds
bethanks1765314_bethanks
bushlands1543404bushlands
cetanes9315134_cet_anes
chelas113817204che_la__s
chelates132713844che_lates
cheloids1438034che_loids
chetahs15347074chet_a_hs
chitlings15255904chitlings
chitlins13289394chitlin_s
coastlands1343314coastlands
croplands1445374croplands
demands114311414_de_mands
deodands1144604_deodands
deplanes11311214_deplanes
desands94810164_de_sands
docklands1743154docklands
downlands1453854downlands
dreamlands1441854dreamlands
dunelands1142774dunelands
eland65820394__e_land_
elans55527754__e_lan_s
errands847604__errands
ethanes103713514__ethanes
expands17195734__expands
farmlands1543864farmlands
fatherlands1852504fatherlands
fenland1135694_fenland_
filmlands1542904filmlands
flatland1264964flatland_
forelands1347174forelands
forestlands1552144forestlands
ganglands1244454ganglands
garlands1038324_garlands
gelants82611444_ge_lants
gellants9308284_gellants
glands85314404___glands
hands95327384_h___ands
hatband1346824_hatband_
headbands1644344_headbands
headends13326724_headends
headland1345614_headland_
heads95127114_he__a_ds
heartland1343654_heartland_
heathland1643964_heathland_
heelings12359754_heelings
hemlines13310624_hemlines
henbanes1336574_henbanes
heptads1335874_hepta_ds
heptanes1339004_heptanes
heralds1137714_he_ralds
hetman112510604_hetman__
hexads17468194_he_xa_ds
hexanes17319464_he_xanes
highlands17114114highlands
holards1148434_h_olards
holland11349474_holland_
homelands1545444homelands
hotlines11811644_hotlines
hotlinks1574194_hotlinks
husbands1444764_husbands
inlands838784__inlands
islands837324__islands
jetlags1533864_jetla_gs
lallands9338574_lallands
lands65426904____lands
lowlands1244374_lowlands
mainlands1244694mainlands
methanes133812164_methanes
midlands1245544_midlands
moorlands1244204moorlands
motherlands1752354motherlands
norlands936444_norlands
northlands1443184northlands
operands1146814ope_rands
outland81212344_outland_
overhands16227804overhands
overland122312004overland_
overlends13237524overlends
parklands1654714parklands
petards104311154_pet_ards
pheasants1443724pheasants
phytanes1645764phyt_anes
pieplants1355434pieplants
pinelands1244934pinelands
playlands1543894playlands
plowlands1542584plowlands
preplans1249614preplan_s
pretends11299114pret_ends
reblends1135294_reblends
reclads1049994_recla_ds
reland75920434_re_land_
relends84013254_re_lends
remands104914884_re_mands
replans92814944_replan_s
replants102811244_replants
retards85015004_ret_ards
rimlands1145244_rimlands
salads75316964s__ala_ds
saltpans1034814saltpan_s
sands65228584s____ands
sarabands1245594sarabands
satangs8479714s_at_angs
scabland1344294scabland_
scends95213004sce___nds
scherzando255714scherzando
scherzandos266634scherzandos
screenlands1451324screenlands
scrublands1551684scrublands
sealant73118304s_ealan_t
seaplanes1148724seaplanes
seastrands1143124seastrands
seawans10379944s_eawan_s
seawants11337974s_eawants
seawards1237204s_eawards
secants93413894s_e_cants
seconds1038284s_e_conds
sedans74816094s_e_dan_s
seedlings11195954seedlings
seitans73312304s_eitan_s
selahs9313214s_e_la_hs
sends65528244s_e___nds
serranids1045534s_erranids
serranos857874s_erranos
servants1138004s_ervants
setbacks1686304s_etbacks
setenants945974s_etenants
setline7313924s_etlin_e
setons64620174s_et_on_s
settings93810074s_ettings
settlings1054684settlings
sewans95215904s_e_wan_s
sextans14349264s_extan_s
sextants15287384s_extants
shads95124484sh___a_ds
shaitans1136414shaitan_s
shamans123610904sh_aman_s
shandy134710034sh___andy
shanks135315584sh___anks
shards104319174sh___ards
sheafs124912884she__a_fs
shealing123415464shealin_g
sheals94420644she__a_ls
shearings13337564shearings
shearlings1443534shearlings
shears93820904she__a_rs
sheas86331794she__a__s
sheathings1743914sheathings
sheaths1358754she__aths
sheaves134412974she__aves
shebang1334844she_ban_g
shebean1235764shebean__
shebeens1343334shebeen_s
sheds96122704she____ds
sheens95116994she__en_s
sheetings13256714sheetings
sheetless1235824sheetl_ess
sheila969844sheila___
sheitan1036574sheitan__
shellac1236694shella__c
shellack1745084shella_ck
shellbacks2153414shellbacks
shellbarks1952624shellbarks
shelled113815094she_lled_
shellers112812584she_llers
shelling123515214shellin_g
shells94319524she_l__ls
shelta93111794shelta___
shelters113412814she_lters
shelties111111384she_lties
shelved14379934she_lved_
shelvers14388814she_lvers
shelves134112094she_l_ves
shelvings16283824shelvings
shend94719974she___nd_
sheols94614164sheol___s
shepherds1843224shepherds
sherds105614724she___rds
sherlocks1843954sherlocks
sherpas1238094sherpa__s
shields11538044shiel__ds
shielings13237124shielings
shillalas12133294shillalas
shillings13348094shillings
shiplaps1544364shipla_ps
shiploads1543814shiploads
shipyards1842984shipyards
shitakes1546114shit_akes
shitheads1645044shitheads
shitless11249244shitl_ess
shitlists1245534shitlists
shitload1294004shitload_
shittahs14114104shitta_hs
shoeblacks2153014shoeblacks
shoelaces1445234shoelaces
shorans102812414sh_oran_s
shorthand1643754shorthand_
shotguns1242314shotgun_s
shrubland1551784shrubland_
shtetlach1751484shtetla_ch
shtetls1034584shtetl___s
sibilants11134804sibilants
sidebands1344444sidebands
silanes72517164s__ilanes
simulants1144994simulants
skeanes113610714ske__anes
skeans104512914ske__an_s
skewbalds1941844skewbalds
skiplanes1544634skiplanes
slangs75615344s___langs
slants64819084s___lants
snowland1243834snowland_
soland75115044s__oland_
solanos74412854s__olanos
solans64122494s__olan_s
soutanes8312934sout_anes
southland1363714southland_
speans85417144spe__an_s
spellbinds1551434spellbinds
spellings12296554spellings
spelunks1442364spe_lunks
spends94714474spe___nds
stand65923284s__t_and_
stanes64933404s__t_anes
stangs75018164s__t_angs
stanks104917704s__t_anks
steads74116224s__tea_ds
stealages1046044stealages
stealings10318854stealings
steelyards1452054steelyards
stellas72813044stella__s
sterilants1044074sterilants
sterlings10308754sterlings
stetsons845624stetson_s
stewards1236384ste_wards
stewpans1343714stewpan_s
stounds8377824s__tounds
strand74514824s__trand_
subclans1247414subclan_s
subtends1136174subt_ends
subtrends1244064subtrends
sultanas8237154sult_anas
sultans72411834sult_an_s
summands1344714s_ummands
sunland837474s_unland_
suntans72111734sunt_an_s
supplants1344874supplants
swamplands1851694swamplands
sweatband1542074sweatband_
sweatpants1551764sweatpants
swellings13296104swellings
tetanus737934_tet_anus
tetrads82910194_tetra_ds
theelins1137644theelin_s
therians1138314therian_s
thetas93011574thet_a__s
thousands1342314thousands
tidelands1144084tidelands
trolands936424_trolands
uhlans937574uh__lan_s
uplands1036944__uplands
upstands1144094upst_ands
urethanes1245164urethanes
urethans1145244urethan_s
videolands1551974videolands
washstands1752134washst_ands
wastelands1442894wastelands
weasands1244564_weasands
weazands2143334_weazands
wessands1243684_wessands
wheelings16284934wheelings
wildlands1443274wildlands
woodlands1444154woodlands
yardlands1443584yardlands

Search took 13 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 Filter1786911653290.513348325.5
2DLD Change Limit16532931911.45314435.4
3Display Results3193190.1432230.8
 (SQL Overall)17869131912.10914756.9
 
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.