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

302 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
sheilas105940(None) 
sheila969841sheila_
chelas113817202che_las
heils85222192_heil_s
sheals94420642sheal_s
sheas86331792she__as
sheikhs17233992sheikhs
sheiks132510012shei_ks
sheitan1036572sheitan
sheitans1155602sheitans
shellac1236692shellac
shellacs1345572shellacs
shells94319522she_lls
sheltas10279672sheltas
sheols94614162sheol_s
sherpas1238092sherpas
shields11538042shields
shiels95418922shiel_s
shills94519612sh_ills
shivas124512412sh_ivas
shrills10389932shrills
speils84116222speil_s
stellas72813042stellas
abelias93213563abelias
akelas10311193ake_las
areolas71013863areolas
ceibas1038503_ceibas
ceilis85413743_ceilis
ceils75019403_ceil_s
challas124414123challas
chela103916803che_la_
chelae113614603che_lae
chias104625523ch_i_as
chicas135916473ch_icas
chields13507483chields
chiels115115933chiel_s
chiles115425303ch_iles
chilis115517873ch_ilis
chills114717703ch_ills
chimlas1437453chimlas
chinas115119403ch_inas
cholas114818003ch_olas
chollas123811353chollas
deils65722863_deil_s
fellas95116963_fellas
hails85231643_hail_s
heals85733463_heal_s
heels85625533_heel_s
hegiras1136103_hegiras
heil76328933_heil__
heiled104415613_heiled
heirs85618563_hei_rs
heists96814633_heists
hejiras1744233_hejiras
heliac111010893_heliac
heliast10312073_heliast
helios94816633_helios
hellos95321683_hellos
hells85032043_he_lls
helms105619463_he_lms
helos84928063_he_los
helps105219343_he_lps
hemiolas1387063_hemiolas
hennas94211803_hennas
herls85226433_herl_s
hila76228353_h_ila_
hilar85418143_h_ilar
hills85431353_h_ills
hilts86924413_h_ilts
hilus84817643_h_ilus
hollas94616903_hollas
hulas84920883_h_ulas
hylas114815903_h_ylas
khedas1446313khe_das
manilas93915873manilas
obelias9279033obelias
ohias84415573oh_i_as
paellas9411413paellas
phials1158873ph_ials
rheas84816953rhe__as
saigas74114293s_aigas
sails55738103s_ail_s
salinas73116093salinas
salivas10309603salivas
scenas84114703sce_nas
schemas1468163sche_mas
scillas9310473scillas
seals54839703s_eal_s
seas45755273s_e__as
seeings84411293seeings
seels55632823s_eel_s
seifs85019333s_ei_fs
seines65029903s_eines
seis45542393s_ei__s
seises64026713s_eises
seisms84912143s_eisms
seitan62613233s_eitan
seitans73312303s_eitans
seizes154317533s_eizes
selah8319613s_e_lah
selahs9313213s_e_lahs
selfs85220243s_e_lfs
selles64426983s_elles
sells55134433s_e_lls
sels46345983s_e_l_s
selvas93812913s_elvas
seniles72618023seniles
sennas64214233s_ennas
sepals85217383s_epals
sepias83616103s_epias
serials73919753serials
shairds11216263shairds
shairns10276783shairns
shaitan1036893shaitan
shaitans1136413shaitans
shales94731253sh_ales
shamas113717943sh_amas
shammas14358723shammas
sharias102516003sharias
shauls94913113shaul_s
shawls125411973shawl_s
shea76031573she__a_
sheaf115424123she__af
sheafs124912883she_afs
sheal84927703she__al
shear85424833she__ar
shears93820903she_ars
sheaths1358753sheaths
sheaves134412973sheaves
shebean1235763shebean
shebeans1344703shebeans
sheds96122703she__ds
sheens95116993she_ens
sheers94322403she_ers
sheets93918503she_ets
sheeves133911953sheeves
sheik122514663shei__k
sheikh16206993shei_kh
shekels1436043shekels
shelf115221113she_l_f
shell84424123she_l_l
shellack1745083shellack
shellacks1844553shellacks
shelled113815093shelled
sheller103515893sheller
shellers112812583shellers
shelly124414473she_lly
shelta93111793she_lta
shelty124011553she_lty
shelve124012763she_lve
shelves134112093shelves
shelvy15377863she_lvy
shends105313773she_nds
sheol84318373sheol__
sheqels1934753sheqels
sherds105614723she_rds
sheriffs17253923sheriffs
sherifs13299683sherifs
sherpa1138093sherpa_
sherris10168803sherris
shes75734353she___s
shetland1244633shetland
shetlands1343743shetlands
sheuchs15234933sheuchs
sheughs14264533sheughs
shewers134312053shewers
shews115924713she__ws
shibah14387473sh_ibah
shibahs15275643sh_ibahs
shiel811023773shiel__
shield106212973shiel_d
shiers94921753sh_iers
shies86136553sh_i_es
shifts124412943sh_ifts
shigellas1343143shigellas
shikar1336803sh_ikar
shikars1436183sh_ikars
shiksa1394653sh_iksa
shiksas1484643shiksas
shill85325333sh_il_l
shily115222013sh_il_y
shims104422553sh_i_ms
shines95028913sh_ines
shins85131043sh_i_ns
shiplap1444513shiplap
shiplaps1544363shiplaps
ships105123773sh_i_ps
shires95225573sh_ires
shirks134814123sh_irks
shirrs94413173sh_irrs
shirts94918343sh_irts
shists96515113sh_ists
shits84731173sh_i_ts
shiva115915003sh_iva_
shivah15488543sh_ivah
shivahs16375723sh_ivahs
shives124921413sh_ives
shivs115018803sh_i_vs
shoals94215793shoal_s
shoebills1443483shoebills
shools94919013shool_s
shorls94516203shorl_s
shrieks14377673shrieks
shrifts1335963shrifts
shrikes144412393shrikes
shrill94712303shril_l
shrilly13318563shrilly
shrimps14516753shrimps
shrines104618693shrines
shrinks14397913shrinks
shris84221453shri__s
shrives134416173shrives
shtetls1034583shtetl_s
shticks16356963shticks
shtiks13297833shti_ks
shuls85319713sh_ul_s
shwas116415103sh__was
sials54227243s__ials
siennas736123siennas
sierras737863sierras
siestas738813siestas
sigils73912363sigil_s
sikas94617023s__ikas
silds65520523s__ilds
silicas9310603silicas
silks94620683s__ilks
sills55135993s__ills
silos56029433s__ilos
silts55330823s__ilts
silvas92912183s__ilvas
simas75727553s__imas
similar937853similar
similes92915233similes
skeins103911903skei_ns
skells105013783ske_lls
skelms12368023ske_lms
skelps12407923ske_lps
skills104313923s_kills
sleighs11245673sleighs
smegmas1233503smegmas
smells83914743sme_lls
smelts85412773sme_lts
smilax1535393s_milax
smiles84522293s_miles
snails64816653snail_s
snells64614203sne_lls
socials999633socials
soils55327983s_oil_s
spails84817823spail_s
specials1238033specials
speels85116393speel_s
speil75618643speil__
speiled104412123speiled
speirs85013233spei_rs
speises93813933speises
speiss84311643spei_ss
spells84617683spe_lls
spelts84614643spe_lts
spicas104715823s_picas
spiels85317953spiel_s
spiles84227913s_piles
spills84717463s_pills
spoils84614533spoil_s
squillas1745333squillas
squills1666313squills
steals64020063steal_s
steels64117983steel_s
steins64818343stei_ns
stela54019043ste_la_
stelae63716483ste_lae
stelai63912563ste_lai
stelar64013863ste_lar
steles63725663ste_les
stella63612973stella_
stellar72610433stellar
stemmas11256973stemmas
sthenias1178163sthenias
stiles64328773s_tiles
stills64118573s_tills
stilts67915313s_tilts
swails94913123swail_s
swells93913983swe_lls
swills94213363s_wills
teslas64212173_teslas
theines104013233theines
theins95015423thei_ns
theirs94610353thei_rs
theisms1237763theisms
theists1039153theists
thetas93011573the_tas
thills95515383th_ills
thrills10398783thrills
thulias1035743thulias
veils84918803_veil_s
wheals124512523wheal_s
wheels123811713wheel_s
whelks16367323whe_lks
whelms14377573whe_lms
whelps14437843whe_lps
whenas124610463whe_nas
whereas13448903whereas
whiles124418013wh_iles

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.610292936.1
2DLD Change Limit1340273027.22018563.3
3Display Results3023020.0933247.3
 (SQL Overall)1786913027.92322553.5
 
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.