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

189 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
sheltie1010991(None) 
shelties111111381shelties
saltie63422432s_altie
selkie102811692s_elkie
sheathe1348992sheathe
sheenie10159492sheenie
shellier1138392shellier
shelta93111792shelt_a
sheltas10279672sheltas
shelter103214962shelter
shelty124011552shelt_y
shelve124012762shel_ve
shelvier1464912shelvier
shortie10411342shortie
svelte9319752svelt_e
sweetie10157872sweetie
belie75630383_bel_ie
bheestie1343153bheestie
bhistie1236773bhistie
challie124012853challie
cheapie1437563cheapie
chedite1338863chedite
chelae113614603chel_ae
chelate122914893chelate
cheloid13310833cheloid
chertier1387873chertier
chestier1387423chestier
deltic9312503_deltic
dhootie1136473dhootie
elite56230183__elite
ghillie11326353ghillie
halite93624233_halite
hectic132311523_hectic
heftier1337203_heftier
heinie92512663_heinie
helio85321193_hel_io
helix154413013_hel_ix
helve115018093_hel_ve
hempie132410563_hempie
hogtie102711773_hogtie
hottie92514383_hottie
kelpie12308613_kelpie
kiltie103210963_kiltie
nellie63614813_nellie
pelite84323003_pelite
philtre12105213philtre
retie55735303_re_tie
saltier74318633s_altier
salties73725773s_alties
saltine75018563s_altine
saltire73113043s_altire
sceptic1337833sceptic
sceptre1135053sceptre
scheelite1444203scheelite
scottie937463scottie
sectile9311973s_ectile
seedtime1144183seedtime
seethe93712483s_eethe
selkies113513353s_elkies
selle54428313s_el_le
seltzer1635213s_eltzer
sente56432883s_ent_e
senti56226703s_enti_
septic102713193s_eptic
septime1138803s_eptime
sestine73017923s_estine
setae56026223s_e_tae
setline7313923s_etline
settee63721023s_ettee
settle63915663s_ettle
sextile1438573s_extile
shale85332833shal__e
shalier103116423shal_ier
shalt85534493shalt__
shanti94014093shanti_
shanties113116593shanties
shantih13309643shantih
shantis103313103shantis
sharpie1238403sharpie
shavie124312423sh_avie
sheath12412893sheat_h
sheathed1547223sheathed
sheather1458233sheather
sheathes14610193sheathes
sheaths1358753sheaths
sheave124514003she_ave
shedlike1635833shedlike
sheenier11167423sheenier
sheenies111411543sheenies
sheet84836963sheet__
sheeted113813043sheeted
sheeter103814913sheeter
sheetfed1544143sheetfed
sheeting122712833sheeting
sheetlike1644333sheetlike
sheets93918503sheet_s
sheeve123412843she_eve
sheik122514663she__ik
sheitan1036573sheitan
shelf115221113shel__f
shelflike1943123shelflike
shell84424123shel__l
shellac1236693shellac
shelled113815093shelled
sheller103515893sheller
shellfire1542513shellfire
shelliest1238033shelliest
shelling123515213shelling
shells94319523shel_ls
shelly124414473shel_ly
sheltered1335573sheltered
shelterer1245033shelterer
shelters113412813shelters
shelved14379933shelved
shelver134211063shelver
shelves134112093shelves
shelviest1535013shelviest
shelving15278173shelving
shelvy15377863shel_vy
shent85933503shent__
sherif122915243she_rif
sherries111812893sherries
sherris10168803sherris
shiftier1436343shiftier
shilpit1247103shilpit
shirtier1137943shirtier
shittier1137313shittier
shittim1245133shittim
shlemiel1393823shlemiel
shoelace1345293shoelace
shortia1048193shortia
shorties11414583shorties
shote85526103sh_ot_e
showtime1643773showtime
shrewdie1542993shrewdie
shtik123210963sh__tik
shute84520353sh_ut_e
shuttle1046103shuttle
sienite7312713sienite
silkie103313403s_ilkie
siltier73413863s_iltier
skelpit1344943skelpit
skelter113610003skelter
skeptic1545203skeptic
sleetier837883sleetier
smalti84111193smalti_
smaltine1037833smaltine
smaltite1046903smaltite
smartie9310173smartie
smectic1336613smectic
smectite1245773smectite
smellier1036793smellier
smelt74726783smelt__
smelted10399093smelted
smelter93311913smelter
smelting11339713smelting
smelts85412773smelt_s
softie93312483s_oftie
sortie63621993s_ortie
specie10412223spe_cie
spectre11297773spectre
spelt75430193spelt__
spelter94113703spelter
spelts84614643spelt_s
speltz174010123spelt_z
speltzes1944003speltzes
steatite8310583steatite
steelie7310213steelie
stelae63716483stel_ae
stelai63912563stelai_
stele55026843stel__e
stelene7310253stelene
stelic8313083stel_ic
stellite839533stellite
stylite10219613stylite
svelter10359673svelter
sweatier1147033sweatier
sweeties11159723sweeties
swelter103711173swelter
sweltrier1242993sweltrier
sweltry1333413sweltry
syenite1039773syenite
tentie62521183_tentie
theatre10358493theatre
thelitis1147513thelitis
thetic11412893the_tic
wellie92814913_wellie
wheelie1336193wheelie
whelkier1833253whelkier

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 Filter1786911340270.403443402.0
2DLD Change Limit1340271896.87619492.0
3Display Results1891890.0802362.5
 (SQL Overall)1786911897.35924282.0
 
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.