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

225 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
shibah1438747(None) 
shibahs15275641shibahs
shivah15488541shivah
shah105627782sh__ah
shikar1336802shikar
shittah1385152shittah
shiva115915002shiva_
shivahs16375722shivahs
shivas124512412shivas
subah106015212s_ubah
whidah1634802whidah
aliyah12397493aliyah
bah87755353___bah
bimah127013273_bimah
casbah1337903casbah
ceiba938703ceiba_
ceibas1038503ceibas
chalah143511663chalah
chetah14399583chetah
chia96026623chi_a_
chiao105618363chi_ao
chias104625523chi_as
chica125818263chica_
chicas135916473chicas
chimar133911473chimar
china105022483china_
chinas115119403chinas
chinch163911233chinch
chiral114614413chiral
chital114313883chital
ghibli1243493ghibli
hah910655223_h__ah
hibachi1744203_hibachi
high116619923_hi_gh
hijab1736803_hijab
hijrah1934283_hijrah
hila76228353_hila_
hilar85418143_hilar
hitch134515473_hitch
horah117922053_horah
jubbah2034353jubbah
kasbah1535183kasbah
khedah1743643khedah
khirkah1641433khirkah
kiblah1535583_kiblah
ohia75719363ohi_a_
ohias84415573ohi_as
phial10313203phi_al
pibal95217323_pibal
rhinal9510193rhinal
sabal75422483s_abal
sabbat10314713sabbat
sabbath1445393sabbath
sahib10314763sahib__
sahibs1137083sahib_s
sahiwal1344443sahiwal
saiga64717933saiga_
saigas74114293saigas
saith85826553sai_th
samba95618773samba_
sambal105215183sambal
sambar103914163sambar
sambas104219263sambas
scribal1137963scribal
scuba94211593scuba_
scubas103710223scubas
seabag938473seabag
seitan62613233seitan
selah8319613s_elah
sha69837783sh__a_
shabby1635803shabby
shad86230913sh__ad
shag86430563sh__ag
shahs115919513sh__ahs
shaitan1036893shaitan
sham96436363sh__am
shaman113314283shaman
shamas113717943shamas
shariah132210533shariah
shat76456603sh__at
shaugh13287433shaugh
shaw108132553sh__aw
shay107133343sh__ay
shazam2046623shazam
shea76031573sh_ea_
sheaf115424123sh_eaf
sheal84927703sh_eal
shear85424833sh_ear
sheas86331793sh_eas
sheath12412893sheath
shebang1334843shebang
shebean1235763shebean
sheesh1237813sheesh
sheikh16206993sheikh
sheila969843sheila_
sheilas1059403sheilas
sheitan1036573sheitan
sheuch14267043sheuch
sheugh13295883sheugh
shh97121073sh___h
shied96125493shi_ed
shiel811023773shi_el
shield106212973shield
shiels95418923shiels
shier85428943shi_er
shiers94921753shiers
shies86136553shi_es
shiest95821523shiest
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
shiv105721173shi__v
shive114423423shi_ve
shiver124517373shiver
shives124921413shives
shivs115018803shi_vs
shmear1176933shmear
shoal83920273sh_oal
shoat85633953sh_oat
shofar1236313shofar
shoran94016043shoran
shush113812543sh_ush
shwa106014963sh_wa_
shwas116415103sh_was
sial45938833s_i_al
sib56850313s_ib__
sibb85921423s_ib_b
sibbs96211903s_ibbs
sibs65933543s_ib_s
sibyl1037113s_ibyl
sidh86222993s_i_dh
sigh85625893s_i_gh
sika86021323s_ika_
sikas94617023s_ikas
sima64730783s_ima_
simar74920813s_imar
simas75727553s_imas
sinh76238043s_i_nh
sirrah9379753sirrah
sisal54217733s_isal
sitar54820543s_itar
sith75435153s_i_th
sixth155512233s_ixth
sizar145214993s_izar
skibob1433423skibob
smilax1535393smilax
smirch1356463smirch
smith107818053smi_th
snib66522983snib__
snibs75613763snib_s
snitch11357943snitch
soba64927923s_oba_
sobas74424253s_obas
spica94717943spica_
spicae104313703spicae
spicas104715823spicas
spilth11469733spilth
spinach1435403spinach
spinal84915313spinal
spiral83715343spiral
spital83813873spital
stibial946583stibial
stich104117923sti_ch
stitch11419103stitch
suba64926603s_uba_
subahs114512383s_ubahs
subas74724073s_ubas
succah1336643succah
sukkah12123733sukkah
sunbath1236423sunbath
sunnah9369353sunnah
surah86823253s_urah
swish115114823swi_sh
switch14458913switch
swith115917403swi_th
thigh12410123thi_gh
thiram1139963thiram
tribal8611133tribal
which163910083whi_ch
whidahs1743333whidahs
whish144512923whi_sh
whydah1942953whydah
yeshivah2051233yeshivah

Search took 6 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.390458182.1
2DLD Change Limit1127162255.50020493.8
3Display Results2252250.0633571.4
 (SQL Overall)1786912255.95330017.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.