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

180 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
sulpha113540(None) 
sulphas1236241sulphas
alpha1049652_alpha
culpa93610962culp_a
salpa75018352salp_a
sulfa8313922sul_fa
sulphate1346642sulphate
sulphid1346112sulphid
sulphur12123872sulphur
supra73614252su_pra
sylph1347792sylph_
sylphs1435542sylphs
sylphy1744152sylphy
aloha8513613_aloha
alphas1139513_alphas
buddha1333173buddha
bugsha1233823bugsha
bulla74620563bul_la
bumph144911983bumph_
bumphs15467103bumphs
buqsha2032793buqsha
culch124512833culch_
culpae10389263culpae
cuppa11398523cu_ppa
dulia61014983dul_ia
epha9310053__epha
fulcra1135213fulcra
fulham1435303ful_ham
gulch113810603gulch_
gulp75521363gulp__
gulped104610373gulped
gulper93410213gulper
gulps84715073gulp_s
gulpy114612763gulp_y
hula74923753hul__a
hulloa95011183hulloa
humph155712213humph_
humphs16528163humphs
huppah1644183huppah
hypha1637383_hypha
kalpa114512193kalp_a
maltha1137503maltha
milpa92111403milp_a
mulch124012973mulch_
muleta839233muleta
mulla74317113mul_la
mullah113710733mullah
murphy1654343murphy
murrha11366453murrha
nucha10229793nu_cha
nullah9388143nullah
nympha1643573nympha
ouph95618373ou_ph_
ouphe104413263ou_phe
ouphs104311273ou_phs
pula65129373pul__a
pulp84825353pulp__
pulpal10408453pulpal
pulped114612533pulped
pulper103513273pulper
pulpit10310933pulpit
pulps95116483pulp_s
pulpy124612363pulp_y
pupa85422813pu_p_a
quotha18365113quotha
ralph1078743ralph_
ralphs1135373ralphs
salina64221123salina
saliva93110743saliva
salp64534093salp__
salpae84614273salpae
salpas85116923salpas
salpian938493salpian
salpid9510883salpid
salps74423243salp_s
salsa56718923sal_sa
salvia93310753salvia
sclera838893sclera
sculch13226213sculch_
sculp95314843sculp__
sculped12398253sculped
sculpin11236653sculpin
sculps104611753sculp_s
sculpt104412693sculp_t
sculpts11377063sculpts
scyphi1643173scyphi
selah8319613selah_
selahs9313213selahs
selva83014273sel_va
sepia75318673s_epia
septa75518083s_epta
sha69837783s___ha
shophar1555463shophar
silica8311243silica
silva82714023sil_va
slush85316573slush_
slushy12417223slushy
sola45541863sol__a
soph97024203s_oph_
sophs104916023s_ophs
sophy136611763s_ophy
spa55730813s__p_a
sradha1085333sradha
staph104314653staph_
staphs114411033staphs
stupa74112313stup_a
suba64926603su__ba
subah106015213subah_
subahs114512383subahs
subpar1048663subpar
subpena1136673subpena
subphase1555603subphase
subphyla1842113subphyla
subsea82610193subsea
succah1336643succah
such96424813su_ch_
sugh86423443su_gh_
sughs95313323su_ghs
sukkah12123733sukkah
sulcal8311273sulcal
sulci7615053sul_ci
sulcus8410493sulcus
suldan72611043suldan
sulfas9311563sulfas
sulfid1039063sulfid
sulfo8313363sul_fo
sulfur937913sulfur
sulk85326653sul__k
sulked114314703sulked
sulker104015923sulker
sulks94818463sul_ks
sulky124715363sul_ky
sullen62914293sullen
sully84622903sul_ly
sulphated1544723sulphated
sulphates1466163sulphates
sulphide1444623sulphide
sulphids1444373sulphids
sulphite1346003sulphite
sulphone1345983sulphone
sulphurs1383653sulphurs
sulphury16122753sulphury
sultan63012593sultan
sultana7257803sultana
sultry938463sultry
sulu45128423sul__u
sulus54821883sul_us
summa94713313su_mma
sump86331533sump__
sumps95023433sump_s
sunna55016063su_nna
sunnah9369353sunnah
sup57041943su_p__
supe65932763su_p_e
super74924483su_per
supes75628303su_pes
supped114415703supped
supper104115433supper
supple10410203supple
supply1346893supply
sups64834433su_p_s
sura45740293su__ra
surah86823253surah_
surahs94515543surahs
surra55521343su_rra
sushi8310493su_shi
sutra54217933su_tra
sutta54015333su_tta
sylphic1745883sylphic
sylphid1645963sylphid
sylva11268443syl_va
syph125413273s_yph_
syphs13519453s_yphs
ulama7711473_ulama
ulema7109713_ulema
ulna46317333_ul_na
ulpan7310123_ulpan
ultra539363_ultra
ulva75412693_ul_va
vulva11448803vul_va

Search took 7 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.423422437.4
2DLD Change Limit1127161806.14018357.7
3Display Results1801800.0632857.1
 (SQL Overall)1786911806.62626968.2
 
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.