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

262 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
shivah1548854(None) 
shibah14387471shibah
shiva115915001shiva_
shivahs16375721shivahs
shivas124512411shivas
shah105627782sh__ah
shibahs15275642shibahs
shikar1336802shikar
shittah1385152shittah
shiv105721172shiv__
shive114423422shiv_e
shiver124517372shiver
shives124921412shives
shivs115018802shiv_s
whidah1634802whidah
yeshivah2051232yeshivah
ajiva1586803ajiva_
ajivas1655133ajivas
aliyah12397493aliyah
bimah127013273_bimah
chalah143511663chalah
chetah14399583chetah
chia96026623chi_a_
chiao105618363chi_ao
chias104625523chi_as
chica125818263chica_
chicas135916473chicas
chimar133911473chimar
china105022483china_
chinas115119403chinas
chinch163911233chinch
chiral114614413chiral
chital114313883chital
chivari1536043chivari
chive135117623chiv_e
chives144317593chives
chivvy20374433chivvy
chivy164810363chiv_y
diva85920883_diva_
divan96114843_divan
divas95418583_divas
estival1036323estival
hah910655223_h__ah
halvah15499833halvah
high116619923_hi_gh
hijab1736803_hijab
hijrah1934283_hijrah
hila76228353_hila_
hilar85418143_hilar
hitch134515473_hitch
hive106029673_hiv_e
hived125217913_hived
hives116925513_hives
horah117922053_horah
khedah1743643khedah
khirkah1641433khirkah
kiva116516413_kiva_
kivas124614733_kivas
mikvah18143473mikvah
nival84915773_nival
ogival1035873ogival
ohia75719363ohi_a_
ohias84415573ohi_as
phial10313203phi_al
rhinal9510193rhinal
rival85216503_rival
sahiwal1344443sahiwal
saiga64717933saiga_
saigas74114293saigas
saith85826553sai_th
saliva93110743saliva_
salivas10309603salivas
seitan62613233seitan
selah8319613s_elah
selva83014273selva_
selvas93812913selvas
serval93913413serval
sha69837783sh__a_
shad86230913sh__ad
shag86430563sh__ag
shahs115919513sh__ahs
shaitan1036893shaitan
sham96436363sh__am
shaman113314283shaman
shamas113717943shamas
shariah132210533shariah
shat76456603sh__at
shaugh13287433shaugh
shave114425893shav_e
shaved135118383shaved
shaven124213303shaven
shaver123718913shaver
shaves125224933shaves
shavie124312423shavie
shaw108132553sh__aw
shay107133343sh__ay
shazam2046623shazam
shea76031573sh_ea_
sheaf115424123sh_eaf
sheal84927703sh_eal
shear85424833sh_ear
sheas86331793sh_eas
sheath12412893sheath
sheave124514003sheave
sheesh1237813sheesh
sheikh16206993sheikh
sheila969843sheila_
sheilas1059403sheilas
sheitan1036573sheitan
sheuch14267043sheuch
sheugh13295883sheugh
shh97121073sh___h
shied96125493shi_ed
shiel811023773shi_el
shield106212973shield
shiels95418923shiels
shier85428943shi_er
shiers94921753shiers
shies86136553shi_es
shiest95821533shiest
shift114225143shi_ft
shifts124412943shifts
shifty15409263shifty
shikari1444513shikari
shikars1436183shikars
shiksa1394653shiksa
shiksas1484643shiksas
shikse1386073shikse
shikseh17102603shikseh
shill85325333shi_ll
shills94519613shills
shily115222013shi_ly
shim95827863shi__m
shimmy16306413shimmy
shims104422553shi_ms
shin75634313shi__n
shindy13449323shindy
shine85533093shi_ne
shined104620783shined
shiner93820873shiner
shines95028913shines
shinny124810783shinny
shins85131043shi_ns
shiny115122143shi_ny
ship95228243shi__p
shiplap1444513shiplap
shipman14247133shipman
ships105123773shi_ps
shipway1844213shipway
shire84727133shi_re
shires95225573shires
shirk124817843shi_rk
shirks134814123shirks
shirr84716923shi_rr
shirrs94413173shirrs
shirt84533903shi_rt
shirts94918343shirts
shirty124312563shirty
shist84829613shi_st
shists96515113shists
shit76745943shi__t
shitake1455623shitake
shits84731173shi_ts
shittahs14114103shittahs
shitty124110063shitty
shivaree1445663shivaree
shivers133714833shivers
shivery16317023shivery
shiviti1344863shiviti
shmear1176933shmear
shoal83920273sh_oal
shoat85633953sh_oat
shofar1236313shofar
shoran94016043shoran
shove114421043shov_e
shoved134214283shoved
shovel124611323shovel
shover124515993shover
shoves124919423shoves
shrieval1443363shrieval
shrive125216953shriv_e
shrived144712183shrived
shrivel13479403shrivel
shriven13379653shriven
shriver134712193shriver
shrives134416173shrives
shush113812543sh_ush
shwa106014963sh_wa_
shwas116415103sh_was
sial45938833s_i_al
sidh86222993s_i_dh
sigh85625893s_i_gh
sika86021323s_ika_
sikas94617023s_ikas
silva82714023silva_
silvae92811093silvae
silvan92810153silvan
silvas92912183silvas
sima64730783s_ima_
simar74920813s_imar
simas75727553s_imas
sinh76238043s_i_nh
sirrah9379753sirrah
sisal54217733s_isal
sitar54820543s_itar
sith75435153s_i_th
siver85728613s_iver
sixth155512233s_ixth
sizar145214993s_izar
skive124614113skiv_e
skived14429893skived
skiver134612103skiver
skives134113943skives
skivvy1932783skivvy
sliver94116593sliver
smilax1535393smilax
smirch1356463smirch
smith107818053smi_th
snitch11357943snitch
snivel9368853snivel
spica94717943spica_
spicae104313703spicae
spicas104715823spicas
spilth11469733spilth
spinach1435403spinach
spinal84915313spinal
spiral83715343spiral
spital83813873spital
spiv95917793spiv__
spivs105114243spiv_s
spivvy1733213spivvy
stich104117923sti_ch
stitch11419103stitch
stiver93915733stiver
subah106015213s_ubah
succah1336643succah
sukkah12123733sukkah
sunnah9369353sunnah
surah86823253s_urah
swish115114823swi_sh
switch14458913switch
swith115917403swi_th
swive115316193swiv_e
swived133610633swived
swivel12369323swivel
swives123915183swives
swivet123615473swivet
sylva11268443sylva_
sylvae12236863sylvae
sylvan12257363sylvan
sylvas12288173sylvas
thigh12410123thi_gh
thiram1139963thiram
viva106119093_viva_
vivas114815023_vivas
which163910083whi_ch
whidahs1743333whidahs
whish144512923whi_sh
whydah1942953whydah
yeshiva1642403yeshiva_
yeshivahs215863yeshivahs
yeshivas1742063yeshivas

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 Filter1786911127160.796224486.2
2DLD Change Limit1127162627.06315958.7
3Display Results2622620.0763447.4
 (SQL Overall)1786912627.93522519.3
 
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.