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

197 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
shariah13221053(None) 
sharia93116731sharia_
shariahs14206391shariahs
sharias102516001sharias
gharial1137342gharial
pariah114320582_pariah
sharif122917122shari_f
sharifs13279902sharifs
sharing113723242sharing
aria46245423__aria_
arias55438023__arias
bearish123013273bearish
bharal1138893bhar_al
boarish123911913boarish
chalah143511663cha_lah
challah15458323challah
charas114223613char_as
charier124317903charier
charily15310283charily
charing133721323charing
chariot12316213chariot
charism14712203charism
charity15311023charity
charka154011703charka_
charkas164810963charkas
charkha19405153charkha
charpai1436633charpai
cherish15310463cherish
chorial124214143chorial
dahabiah1742863dahabiah
dharma1276103dharma_
dharmas1356513dharmas
dharna1055263dharna_
dharnas1155373dharnas
garish104516923_garish
gharials1245123gharials
hadith13312063_hadith
hallah124115403_hallah
halvah15499833_halvah
hamzah23135563_hamzah
hariana10310243_hariana
harijan1735783_harijan
haring104233003_haring
harsh116418053_har_sh
hartal9415473_hartal
horah117922053_hor_ah
hurrah12369183_hurrah
jarrah1636683_jarrah
khirkah1641433khirkah
lariat6629043_lariat
maria75032883_maria_
marish114319053_marish
narial6317953_narial
ovarial1037613ovarial
ovarian1037643ovarian
pardah123412823_pardah
pariahs123812343_pariahs
parian83223963_parian
parish115022353_parish
pharaoh1545033pharaoh
saith85826553s_a_ith
salariat8416303salariat
saran53730303s_ar_an
sardar73013173s_ardar
sari45444043s_ari__
sarin55239253s_ari_n
sarins63932623s_arins
saris54544953s_ari_s
sarsar63011843s_arsar
saurian739913saurian
scarab10310063scar_ab
scarier94017873scarier
scarify1537443scarify
scarily12311703scarily
scaring103421973scaring
scarph13429603scar_ph
scoria8513503scoria_
scoriae9310903scoriae
scraich1436763scraich
scraigh1335673scraigh
search113312423sear_ch
searing83330923searing
serial64625863s_erial
shadier113111153shadier
shadily1437723shadily
shading123115563shading
shadrach1743973shadrach
shah105627783sh___ah
shaird10288703sha_ird
shairds11216263shairds
shairn9269063sha_irn
shairns10276783shairns
shaitan1036893shaitan
shakier143411153shakier
shakily1736903shakily
shaking153317253shaking
shalier103116423shalier
shaman113314283sha_man
shamas113717943sha_mas
shaming133016743shaming
shammas14358723shammas
shammash18293753shammash
shantih13309643shantih
shaping133116183shaping
shard96125963shar__d
shards104319173shar_ds
share86437083shar__e
shared105829063shar_ed
sharer95025483shar_er
sharers104720623sharers
shares95236413shar_es
sharifian1542783sharifian
shark126225023shar__k
sharked153613913sharked
sharker144313813sharker
sharking163912973sharking
sharks135019723shar_ks
sharn84823703shar__n
sharns95516983shar_ns
sharny124711833shar_ny
sharp104922533shar__p
sharped134112053sharped
sharpen12389723sharpen
sharper124312703sharper
sharpie1238403sharpie
sharpies13411233sharpies
sharping143011373sharping
sharply15406833sharply
sharps115516083shar_ps
sharpy145211033shar_py
shaugh13287433sha_ugh
shavie124312423shavi_e
shavies134213213shavies
shaving143414333shaving
shawing143514883shawing
shazam2046623sha_zam
shearing123915903shearing
sheikh16206993sh_eikh
sherif122915243sheri_f
sheriff16287693sheriff
sherifs13299683sherifs
sherpa1138093sherpa_
sherpas1238093sherpas
shibah14387473sh_ibah
shittah1385153shittah
shivah15488543sh_ivah
shoran94016043shor_an
shoring112820073shoring
shortia1048193shortia_
shortias1148093shortias
shortish1437423shortish
shri76021703sh_ri__
shriek134211103sh_riek
shrift12413543sh_rift
shrike134513243sh_rike
shrill94712303sh_rill
shrimp13478773sh_rimp
shrine94920053sh_rine
shrink134511733sh_rink
shris84221453sh_ri_s
shrive125216953sh_rive
sirrah9379753s_irrah
slavish1338233slavish
snaring83920953snaring
soaring83521893soaring
solaria7312493solaria_
sourish10310693sourish
spacial1138763spacial
sparid94016933spari_d
sparids103512123sparids
sparing104823873sparing
sparkish17276973sparkish
spartan948333spartan
spatial9310323spatial
squarish2047323squarish
stadia7312143stadia_
stadias8411113stadias
starch113013203star_ch
starfish1438083starfish
staring84527053staring
stria55723213s_tria_
striae65422273s_triae
sudaria847973sudaria_
surah86823253s_ur_ah
svaraj1634963svar_aj
swaraj1636023swar_aj
swarth126012083swar_th
theriac1239143theriac
therian10311293therian
thoria93012893thoria_
thorias102312053thorias
varia85824203_varia_
varias95019903_varias
wearish132310153wearish
whorish1636603whorish
zoaria1548383zoaria_
zoarial1646923zoarial

Search took 9 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.470380193.6
2DLD Change Limit1340271978.03016690.8
3Display Results1971970.330597.0
 (SQL Overall)1786911978.83020236.8
 
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.